transformations:enumerategroups
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.txt · Last modified: 2021/04/05 10:13 by dmitry
Page Tools
