transformations:enumerate
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
transformations:enumerate [2019/11/19 07:35] – added grouping dmitry | transformations:enumerate [2021/03/21 14:26] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Enumerate rows ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Basic | ||
- | This transformation | + | =====Description===== |
+ | This action | ||
- | **Example** | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Enumerate in groups|Select this option to restart row numbering at each unique value in the selected column(s). | | ||
+ | |Column list|This list appears when the //Enumerate in groups// is selected. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Source table** | ||
+ | ^ Province | ||
+ | | ON | Toronto | ||
+ | | ON | Ottawa | ||
+ | | ON | Brampton | ||
+ | | QC | Montreal | ||
+ | | QC | Quebec City | 2000| 270| | ||
- | Before transformation | ||
- | ^Province | ||
- | | ON | 1000| 125| | ||
- | | ON | 1500| 187.5| | ||
- | | QC | 2000| 270| | ||
After transformation (enumeration for entire table). | After transformation (enumeration for entire table). | ||
- | ^RowNo ^Province | + | ^ RowNo ^ Province |
- | | 1| ON | 1000| | + | | 1| ON |
- | | 2| ON | 1500| 187.5| | + | | 2| ON |
- | | 3| QC | 2000| 270| | + | | 3| ON | Brampton |
+ | | 4| QC | | ||
+ | | 5| QC | Quebec City | 2000| | ||
After transformation (enumeration for each Province). | After transformation (enumeration for each Province). | ||
- | ^RowNo ^Province | + | ^ RowNo ^ Province |
- | | 1| ON | 1000| | + | | 1| ON |
- | | 2| ON | 1500| 187.5| | + | | 2| ON |
- | | 1| QC | 2000| 270| | + | | 3| ON | Brampton |
+ | | 1| QC | Montreal | ||
+ | | 2| QC | Quebec City | 2000| 270| | ||
+ | |||
+ | After transformation (enumeration for each Province-Amount pairing). | ||
+ | ^ RowNo ^ Province | ||
+ | | 1| ON | Toronto | ||
+ | | 2| ON | Ottawa | ||
+ | | 1| ON | Brampton | ||
+ | | 1| QC | | ||
+ | | 2| QC | Quebec City | 2000| 270| | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | *[[transformations: |
transformations/enumerate.txt · Last modified: 2022/11/12 22:56 by craigt