Row Num

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Row Num


Add a new column that contains the row number.



Add a row number starting at 1:


how to add a row number column example






Set Start at to the number you want to use for the first row.

Set Increment to the amount you wish to increment by.

set Every to how often to apply the increment (e.g. set to 5 to increment once every 5 rows).



The new column is added at the right end. You can change the column order with Reorder Cols and the column name with Rename Cols.

You can Pad the row number with zeros to turn it into a column of unique Ids with a fixed length.