transformations:enumerate
Differences
This shows you the differences between two versions of the page.
Next revisionBoth sides next revision | |||
transformations:enumerate [2014/10/03 21:53] – created dmitry | transformations:enumerate [2019/11/19 07:35] – added grouping dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Enumerate rows ===== | ===== Enumerate rows ===== | ||
- | This transformation adds a new column with row number | + | This transformation adds a new column with row numbers. Rows can be enumerated either |
**Example** | **Example** | ||
Line 8: | Line 8: | ||
^Province | ^Province | ||
| ON | 1000| 125| | | ON | 1000| 125| | ||
- | | | + | | |
| QC | 2000| 270| | | QC | 2000| 270| | ||
- | After transformation | + | After transformation |
^RowNo ^Province | ^RowNo ^Province | ||
| 1| ON | 1000| 125| | | 1| ON | 1000| 125| | ||
- | | 2| | + | | 2| |
| 3| QC | 2000| 270| | | 3| QC | 2000| 270| | ||
+ | |||
+ | After transformation (enumeration for each Province). | ||
+ | ^RowNo ^Province | ||
+ | | 1| ON | 1000| 125| | ||
+ | | 2| ON | 1500| 187.5| | ||
+ | | 1| QC | 2000| 270| |
transformations/enumerate.txt · Last modified: 2022/11/12 22:56 by craigt