Skip to main content

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.


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

Record ID anchors.png

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

  1. In New Column Header, enter a name for the new column.

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

  3. Select a Data Type.

  4. Use Position to select a position for your new column: First Column or Last Column.

  5. Add columns to the Sort by Column table. Select the Column Name and Order.