transformations:enumerategroups
This is an old revision of the document!
Enumerate rows
This action adds a new column with generated group numbers. A group is defined by 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.1601973667.txt.gz · Last modified: 2020/10/06 04:41 by dmitry