| Output Column Name | Name of the new column that will contain the generated record IDs. |
| Starting Value | The first number in the sequence. |
| Data type | Select integer or string as the output type of the record ID values. |
| Size (String only) | Total number of characters in the string.
Leading zeros will be added if the starting value is shorter than the defined size. |
| Column position | Choose to add as first column or add as last column in the output dataset. |
| Record ID Generation Scope | Specify whether to generate IDs across entire table or within each group defined by selected columns. |
| Group By Columns | When generating IDs within groups, choose one or more columns to group the data by. |
| Order Rows Within Each Group (Optional) | (Optional) Define the columns to determine the order in which rows are numbered within each group. You can select multiple columns and sort them in ascending or descending order. |
