transformations:enumerategroups
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:enumerategroups [2021/04/05 10:13] – dmitry | transformations:enumerategroups [2021/07/19 02:26] (current) – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Enumerate groups | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | This action | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | **Example** | + | A " |
- | Before: | + | \\ |
+ | =====Use cases===== | ||
+ | The action is can be used to create group ID numbers for later reference, lookups, or merges.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Column|Select the column or columns to base the group numbers on.| | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | | ||
+ | |||
+ | The new column containing the group numbers will be named " | ||
+ | |||
+ | When multiple columns are selected, the unique combinations of values across the selected columns are what constitutes the " | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Example 1:** Enumerate groups based on the values in the " | ||
+ | |||
+ | **Source table:** | ||
^Province | ^Province | ||
| ON | 1000| 125| | | ON | 1000| 125| | ||
| ON | 1500| 187.5| | | ON | 1500| 187.5| | ||
| QC | 2000| 270| | | QC | 2000| 270| | ||
- | + | \\ | |
- | After (groups are defined by column | + | **Action parameters: |
+ | > Column | ||
+ | \\ | ||
+ | **Result table:** | ||
^GroupNo ^Province | ^GroupNo ^Province | ||
| 1| ON | 1000| 125| | | 1| ON | 1000| 125| | ||
| 1| ON | 1500| 187.5| | | 1| ON | 1500| 187.5| | ||
- | | 2| QC | 2000| 270| | + | | 2| QC | 2000| 270| |
+ | |||
+ | \\ \\ \\ | ||
+ | **Example 2:** Generate group numbers from the values in the selected columns.\\ | ||
+ | |||
+ | **Source table:** | ||
+ | ^FirstName | ||
+ | |Mary |K |Jones | | ||
+ | |Sam |A |Walker | | ||
+ | |Mary |M |Doe | | ||
+ | |Reggie |B |Monroe | | ||
+ | |Sam |D |Walker | | ||
+ | |Trisha |E |West | | ||
+ | |Sam |A |Adams | | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Column " | ||
+ | \\ | ||
+ | **Result table:** | ||
+ | ^GroupNo ^FirstName | ||
+ | |1|Mary |K |Jones | | ||
+ | |2|Sam |A |Walker | | ||
+ | |1|Mary |M |Doe | | ||
+ | |3|Reggie |B |Monroe | | ||
+ | |2|Sam |D |Walker | | ||
+ | |4|Trisha |E |West | | ||
+ | |2|Sam |A |Adams | | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Column " | ||
+ | \\ | ||
+ | **Result table:** | ||
+ | ^GroupNo ^FirstName | ||
+ | |1|Mary |K |Jones | | ||
+ | |2|Sam |A |Walker | | ||
+ | |3|Mary |M |Doe | | ||
+ | |4|Reggie |B |Monroe | | ||
+ | |2|Sam |D |Walker | | ||
+ | |5|Trisha |E |West | | ||
+ | |6|Sam |A |Adams | ||
- | ==== See also ==== | + | \\ |
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | \\ | ||
+ | =====See also===== | ||
* [[transformations: | * [[transformations: |
transformations/enumerategroups.txt · Last modified: 2021/07/19 02:26 by craigt