Index Transformation
The Index transformation sets up a new column with numbered rows. You can set the starting number of the index. If you create more than one index column, the column name is appended with a number.
You can set the starting number of the index. If you create more than one index column, the column name is appended with a number.
Index can be used as a way to uniquely identify a row, or as a simple counting mechanism.