New steps and updated steps

Limit rows

A new step to make filtering down data easier. Use this step to limit the number of rows that pass through it. You can keep or remove a certain number of rows from the top, bottom, or random positions in a table. This step is also great if you need to pick a random row or set of rows.

Fill in blanks

Previously called the Fill Down step, this step can now fill in blank cells in many ways. You can find the nearest value from above, below, to the left, or to the right of your blank and use it. You can also fill in blanks with a value you type out, including values from columns you reference with a {merge tag}.

Clean data

A new step to make your data easier to work with! Remove trailing or leading spaces, which can be tough to handle normally. Remove unwanted characters such as letters, numbers, or punctuation. Also use this step to replace our old magic cleaning step to prepare your data to be sent through an API!

Split columns

This step looks different but functions the same way. The step can no longer rename the columns that it creates.

Insert text column

This step takes the place of the older Insert column and Insert static text column steps, and combines their functionality. You can insert a column with a value, and reference other column values. By default, if the column that the step is trying to add already exists, the new column will not be added. But that can be toggled off.

Insert Row Numbers

This step gained a lot of new functionality. Add row numbers down the whole table, add numbers that repeat after a certain number of rows, repeat each number a set number of times before advancing to the next number, and number based on another column. Numbering based on another column is a powerful way to add numbers to things like line items that share an order ID, or to rank your data.

4 Likes