Record ID
What is the ‘Record ID’ task?
The ‘Record ID’ task can be used to add a column with serial numbers to a data table. On applying the ‘Record ID’ task, the output table will include a new data column, which will have serial numbers for all entries.
How to use the ‘Record ID’ task?
The important fields in the ‘Record ID’ task are
- Select Table
Use this dropdown menu to select the table in which you would like to add the serial numbers.
- New Column Name
Use this field to type in the name of the column in the output table that will house the serial numbers.
- Starting Value
Use this field to type in the starting value of the serial numbers. The first entry in the data table will receive this as the serial number.
- Position
Use this dropdown menu to select if the new column with the serial numbers should be the first or the last column in the output table.
How to use the ‘Define Output Table’ and the ‘Output Options’ sections in the ‘Record ID’ task?
The ‘Output Options’ section in the ‘Record ID’ task can be used to modify features of the output table. The fields related to this section become visible on selecting the ‘Output Options’ checkbox.
More information about this section is available here.