Table of Contents

ENUMERATE ROWS

Category: Transform / Basic


Description

This action adds a new column with row numbers.

Rows can be enumerated:


Use cases


Action settings

SettingDescription
Enumerate in groupsSelect this option to restart row numbering at each unique value in the selected column(s).
Repeat after*Enter or set a maximum value after which the count resets to 1. Check the Add column with repetition count to
add a column (named "Repetition") that displays the count of the repetition.
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.

* Setting can be specified using a parameter.


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


After transformation (Repeat after "2").

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


After transformation (Repeat after "2", Add column with repetition count).

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


Community examples


See also