Row ID
Create an ID column in your dataset
The Row ID is pleasantly simple. It creates a new column with a ID ranging from 0 to however many rows your data set contains. You can use a Group By functionality (see the configuration guide below) to create IDs within certain groups of your data.
Configuration
The Row ID tool doesn’t have any required input. It will simply add a new Row ID column to your dataset if you just run the tool.
However, you can choose to add IDs within groups.
Additional Settings Groups
This is an optional input. Select the columns that you want to group by when creating IDs. The IDs will created inside each of these groups. Check out the example to see how it works.
When To Use
Obvoiusly the Row ID tool is helpful to get track of your data, but it empowers a couple of cools things. Such as:
- Whenever you only want a subset of records within some group
- To create an ID column which can be used as the input for the Parse JSON tool