Articles on: Transforms

Insert row numbers

The Insert row number step creates a new column adding sequential numbers to each row.
You can also add row number based on each set of rows having the same column data, each set of rows will have its own range of sequential numbers.

Insert row numbers





Input/output



The input data we'll use with this step is a table contains "ProductName" column.





The new output table has an additional column named "Index". Each set of rows with same "ProductName" will have its own range of numbers starts with 1 and increases.




Settings



Pick the dataset.
Type the "New column name" and the "Start with" number,
Then Specify the "Number settings":
Number the entire table: It will add row number for the entire table sequentially
Number based on column : Each set of rows with the same column data, will have its own sequential numbers.

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: 20/09/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!