Row Num

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Row Num

Description

Add a new column that contains the row number.

 

Example

Add a row number starting at 1:

 

how to add a row number column example

 

Inputs

One.

 

Options

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).

 

Notes

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.