Record ID tool icon

Record ID Tool

Last modified: September 09, 2021

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

One Tool Example

Record ID has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer Cloud.

Use Record ID to create a new column in the data and assign a unique identifier, which increments sequentially for each row in the data. The Record ID tool generates unique identifiers with numeric values or string values, depending on the data type you select.

Use the Record 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 Record ID column.

Configure the Tool

To create a new column...

  1. In New Column Header, enter a name for the new column.
  2. In Starting Value, enter or select the value to display in the first record. The Record ID tool assigns that value and then increases the value sequentially for each record.
  3. Use the Type dropdown to select a data type. If you select String, enter or select the size of the string in Size. If necessary, Designer Cloud adds leading zeros to the record to equal the string size you select.
  4. Use Position dropdown to select a position for your new column: First Column or Last Column.
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.