The Auto Number node is useful node allows you to give row numbers to a preexisting data set that does not have them.
Row numbering starts at 0.
-
Row Number Field Name- the name you want to give to the new field containing the row numbers. -
Sort Order for Numbering- specify a field to sort by before numbering.
For example: Specifying row as the Row Number Field Name and state (Ascending) as the Sort Order for Numbering Field on the following data set,
|
state |
city |
measure |
|---|---|---|
|
Illinois |
Chicago |
98 |
|
Arkansas |
Little Rock |
96 |
|
New York |
Buffalo |
95 |
Would result in the following numbered data set, sorted by state name in ascending order.
|
state |
city |
measure |
row |
|---|---|---|---|
|
Arkansas |
Little Rock |
96 |
0 |
|
Illinois |
Chicago |
98 |
1 |
|
New York |
Buffalo |
95 |
2 |
Tip: Auto Number can be particularly useful if you need to generate a unique id for each record in your data set.