transformations:enumerategroups
This is an old revision of the document!
Enumerate groups
This action adds a new column with generated group numbers. A group is defined by a column or a combination of columns. Groups are enumerated starting from 1.
Example
Before:
| Province | Amount | Total Tax |
|---|---|---|
| ON | 1000 | 125 |
| ON | 1500 | 187.5 |
| QC | 2000 | 270 |
After (groups are defined by column "Province"):
| GroupNo | Province | Amount | Total Tax |
|---|---|---|---|
| 1 | ON | 1000 | 125 |
| 1 | ON | 1500 | 187.5 |
| 2 | QC | 2000 | 270 |
See also
transformations/enumerategroups.1617632021.txt.gz · Last modified: 2021/04/05 10:13 by dmitry