The Insert row number step creates a new column adding sequential numbers to each row.

You can sort the numbers in ascending or descending order. You can add row numbers down the whole table, add numbers that repeat after a certain number of rows, repeat each number a set amount 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.

Insert row numbers

Input/output

The input data we'll use with this step is a table of 6 rows with the columns "Product ID" and "Name".

The new output table has an additional column named "Row Number". The first cell in the column starts with 1 and increases in ascending order. The step will add a new column with sequential row numbers to any connected dataset.

Settings

By default, the Column Name will be set to Row Number, Start with will be set to 1, and the order will be ascending.

To sort the numbers in descending order, expand the "Numbering Settings" section and change the default setting from the top to the bottom. The numbers will now be sorted from highest to lowest.

To see how many times a certain data type (like a product) appears in your data set, you can change Number the entire table to Number based on a column such as "Name", "Product ID", and more.

There are also options to have this "Row number" column repeat the same integer a certain amount of times (Repeat numbers) or restart after a certain amount of rows (Restart after).

Helpful tips

If two tables have the same number of rows but do not share a matching column, use this step and then the Combine tables step to create a new column that you can use to combine the tables.

You can sort the numbers in ascending or descending order. You can add row numbers down the whole table, add numbers that repeat after a certain number of rows, repeat each number a set amount 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.

Insert row numbers

Input/output

The input data we'll use with this step is a table of 6 rows with the columns "Product ID" and "Name".

The new output table has an additional column named "Row Number". The first cell in the column starts with 1 and increases in ascending order. The step will add a new column with sequential row numbers to any connected dataset.

Settings

By default, the Column Name will be set to Row Number, Start with will be set to 1, and the order will be ascending.

To sort the numbers in descending order, expand the "Numbering Settings" section and change the default setting from the top to the bottom. The numbers will now be sorted from highest to lowest.

To see how many times a certain data type (like a product) appears in your data set, you can change Number the entire table to Number based on a column such as "Name", "Product ID", and more.

There are also options to have this "Row number" column repeat the same integer a certain amount of times (Repeat numbers) or restart after a certain amount of rows (Restart after).

Helpful tips

If two tables have the same number of rows but do not share a matching column, use this step and then the Combine tables step to create a new column that you can use to combine the tables.

Updated on: 11 / 05 / 2022