transformations:enumerate
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:enumerate [2014/10/03 21:53] – created 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. | ||
- | Before | + | \\ |
- | ^Province | + | =====Examples===== |
- | | ON | 1000| | + | |
- | | | + | **Source table** |
- | | QC | 2000| 270| | + | ^ Province |
+ | | ON | Toronto | ||
+ | | ON | Ottawa | ||
+ | | ON | Brampton | ||
+ | | QC | Montreal | ||
+ | | QC | Quebec City | 2000| 270| | ||
+ | |||
+ | |||
+ | After transformation | ||
+ | ^ | ||
+ | | 1| ON | ||
+ | | | ||
+ | | 3| ON | Brampton | ||
+ | | 4| QC | Montreal | ||
+ | | 5| QC | Quebec City | 2000| 270| | ||
+ | |||
+ | After transformation (enumeration for each Province). | ||
+ | ^ RowNo ^ Province | ||
+ | | 1| ON | Toronto | ||
+ | | 2| ON | Ottawa | ||
+ | | 3| ON | Brampton | ||
+ | | 1| QC | | ||
+ | | 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 | Montreal | ||
+ | | 2| QC | Quebec City | 2000| 270| | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | *[[transformations: | ||
- | After transformation | ||
- | ^RowNo ^Province | ||
- | | 1| ON | 1000| 125| | ||
- | | 2| OM | 1500| 187.5| | ||
- | | 3| QC | 2000| 270| |
transformations/enumerate.txt · Last modified: 2022/11/12 22:56 by craigt