transformations:enumerate
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:enumerate [2019/11/19 07:35] – added grouping dmitry | transformations:enumerate [2022/11/12 22:56] (current) – udpate with new Repeat after setting (v5.3.1) craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Enumerate rows ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Basic\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | **Example** | + | Rows can be enumerated: |
+ | | ||
+ | | ||
+ | | ||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | | ||
+ | *To define an original record order with which to re-sort records downstream. | ||
+ | *Prepare datasets for pivoting by setting a defined number of rows and row groupings (repetitions). | ||
- | Before transformation | + | \\ |
- | ^Province | + | =====Action settings===== |
- | | | + | ^Setting^Description^ |
- | | | + | |Enumerate in groups|Select this option to restart row numbering at each unique value in the selected column(s). |
- | | | + | |Repeat after< |
+ | |Column list|This list appears when the //Enumerate in groups// is selected. | ||
+ | < | ||
- | After transformation (enumeration for entire table). | + | \\ |
- | ^RowNo ^Province | + | =====Examples===== |
- | | 1| ON | 1000| 125| | + | |
- | | 2| ON | 1500| 187.5| | + | |
- | | 3| QC | 2000| 270| | + | |
+ | **Source table:** | ||
+ | ^Province | ||
+ | |ON |Toronto | ||
+ | |ON |Ottawa | ||
+ | |ON |Brampton | ||
+ | |QC |Montreal | ||
+ | |QC |Quebec City | 2000| 270| | ||
+ | |||
+ | \\ | ||
+ | After transformation (enumeration for entire table). | ||
+ | ^RowNo | ||
+ | | 1|ON |Toronto | ||
+ | | 2|ON |Ottawa | ||
+ | | 3|ON |Brampton | ||
+ | | 4|QC |Montreal | ||
+ | | 5|QC |Quebec City | 2000| 270| | ||
+ | \\ | ||
After transformation (enumeration for each Province). | After transformation (enumeration for each Province). | ||
- | ^RowNo ^Province | + | ^RowNo |
- | | 1| ON | 1000| | + | | 1|ON |Toronto |
- | | 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 | ||
+ | | 1|ON | ||
+ | | 2|ON |Ottawa | ||
+ | | 1|ON |Brampton | ||
+ | | 1|QC |Montreal | ||
+ | | 2|QC |Quebec City | 2000| 270| | ||
+ | \\ | ||
+ | After transformation (Repeat after " | ||
+ | ^RowNo | ||
+ | | 1|ON |Toronto | ||
+ | | 2|ON |Ottawa | ||
+ | | 1|ON |Brampton | ||
+ | | 2|QC |Montreal | ||
+ | | 1|QC |Quebec City | 2000| 270| | ||
+ | \\ | ||
+ | After transformation (Repeat after " | ||
+ | ^RowNo | ||
+ | | 1| 1|ON |Toronto | ||
+ | | 2| 1|ON |Ottawa | ||
+ | | 1| 2|ON |Brampton | ||
+ | | 2| 2|QC |Montreal | ||
+ | | 1| 3|QC |Quebec City | 2000| 270| | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | *[[transformations: | ||
+ | *[[transformations: |
transformations/enumerate.1574166951.txt.gz · Last modified: 2019/11/19 07:35 by dmitry