transformations:enumerate
Differences
This shows you the differences between two versions of the page.
|
transformations:enumerate [2014/10/04 01:53] dmitry created |
transformations:enumerate [2019/11/19 12:35] (current) dmitry added grouping |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== Enumerate rows ===== | ===== Enumerate rows ===== | ||
| - | This transformation adds a new column with row number for all rows starting from top. It doesn't have parameters. | + | This transformation adds a new column with row numbers. Rows can be enumerated either for the entire table, or inside groups defined by combinations of values in particular columns. In the latter case, row numbers restart from 1 inside each group. |
| **Example** | **Example** | ||
| Line 8: | Line 8: | ||
| ^Province ^Amount ^Total Tax ^ | ^Province ^Amount ^Total Tax ^ | ||
| | ON | 1000| 125| | | ON | 1000| 125| | ||
| - | | OM | 1500| 187.5| | + | | ON | 1500| 187.5| |
| | QC | 2000| 270| | | QC | 2000| 270| | ||
| - | After transformation | + | After transformation (enumeration for entire table). |
| ^RowNo ^Province ^Amount ^Total Tax ^ | ^RowNo ^Province ^Amount ^Total Tax ^ | ||
| | 1| ON | 1000| 125| | | 1| ON | 1000| 125| | ||
| - | | 2| OM | 1500| 187.5| | + | | 2| ON | 1500| 187.5| |
| | 3| QC | 2000| 270| | | 3| QC | 2000| 270| | ||
| + | |||
| + | After transformation (enumeration for each Province). | ||
| + | ^RowNo ^Province ^Amount ^Total Tax ^ | ||
| + | | 1| ON | 1000| 125| | ||
| + | | 2| ON | 1500| 187.5| | ||
| + | | 1| QC | 2000| 270| | ||
transformations/enumerate.txt · Last modified: 2019/11/19 12:35 by dmitry
Page Tools
