User Tools

Site Tools


transformations:enumerate

ENUMERATE ROWS

Category: Transform / Basic


Description

This action adds a new column with row numbers. Rows can be enumerated for either the entire table or inside groups defined by combinations of values in particular columns. In the latter case, row numbers restart from 1 inside each group.


Use cases

  • Create unique row IDs for datasets that do not already possess a unique key field.
  • To define an original record order to re-sort records by downstream.


Action settings

SettingDescription
Enumerate in groupsSelect this option to restart row numbering at each unique value in the selected column(s).
Column listThis list appears when the Enumerate in groups is selected. Select which columns are taken into account to
form unique values when numbering columns. Column numbering will restart at 1 for each unique value or value
combination across all selected columns.


Examples

Source table

Province City Amount Total Tax
ON Toronto 1000 125
ON Ottawa 1000 125
ON Brampton 2000 250
QC Montreal 2000 270
QC Quebec City 2000 270

After transformation (enumeration for entire table).

RowNo Province City Amount Total Tax
1ON Toronto 1000 125
2ON Ottawa 1000 125
3ON Brampton 2000 250
4QC Montreal 2000 270
5QC Quebec City 2000 270

After transformation (enumeration for each Province).

RowNo Province City Amount Total Tax
1ON Toronto 1000 125
2ON Ottawa 1000 125
3ON Brampton 2000 250
1QC Montreal 2000 270
2QC Quebec City 2000 270

After transformation (enumeration for each Province-Amount pairing).

RowNo Province City Amount Total Tax
1ON Toronto 1000 125
2ON Ottawa 1000 125
1ON Brampton 2000 250
1QC Montreal 2000 270
2QC Quebec City 2000 270


See also

transformations/enumerate.txt · Last modified: 2021/04/05 10:13 by dmitry