Row ID Tool
Use Row ID to create a new column in the data and assign a unique identifier, which increments sequentially for each row in the data.
The Row ID tool generates unique identifiers with numeric values or string values, depending on the data type you select.
Use the Row ID tool to assign a sequence to data. Sort the data in other columns and then return the data to its original order by sorting the values in the new Row ID column.
Tip
This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.
Tool Components
 |
Figure: Row ID Tool with anchors.
The Row ID tool has 2 anchors.
Input anchor: Use the input anchor to select the data you want to assign a sequence to.
Output anchor: Outputs the data that has a new column with assigned unique identifiers.
Configure the Tool
To create a new column...
In New Column Header, enter a name for the new column.
In StartingValue, enter or select the value to display in the first row. The Row ID tool assigns that value and then increases the value sequentially for each row.
Select a Data Type.
Use Position to select a position for your new column: First Column or Last Column.
(Optional) Select Columns to Group By to create row IDs within groups specified in a column.