User Tools

Site Tools


transformations:enumerategroups

ENUMERATE GROUPS

Category: Transform / Advanced


Description

This action generates group numbers in a new column.

A "group" is defined by unique values in a column or unique combinations of values across multiple columns.


Use cases

The action is can be used to create group ID numbers for later reference, lookups, or merges.


Action settings

SettingDescription
ColumnSelect the column or columns to base the group numbers on.


Remarks

Groups are enumerated starting from 1.

The new column containing the group numbers will be named "GroupNo" and appear as the leftmost column, by default.

When multiple columns are selected, the unique combinations of values across the selected columns are what constitutes the "groups".


Examples

Example 1: Enumerate groups based on the values in the "Province" column.

Source table:

Province Amount Total Tax
ON 1000 125
ON 1500 187.5
QC 2000 270


Action parameters:

Column "Province" is selected


Result table:

GroupNo Province Amount Total Tax
1 ON 1000 125
1 ON 1500 187.5
2 QC 2000 270




Example 2: Generate group numbers from the values in the selected columns.

Source table:

FirstName Middle Init LastName
Mary K Jones
Sam A Walker
Mary M Doe
Reggie B Monroe
Sam D Walker
Trisha E West
Sam A Adams


Action parameters:

Column "FirstName" is selected


Result table:

GroupNo FirstName Middle Init LastName
1Mary K Jones
2Sam A Walker
1Mary M Doe
3Reggie B Monroe
2Sam D Walker
4Trisha E West
2Sam A Adams


Action parameters: (Using the same source table, above.)

Column "FirstName" and "LastName" are selected


Result table:

GroupNo FirstName Middle Init LastName
1Mary K Jones
2Sam A Walker
3Mary M Doe
4Reggie B Monroe
2Sam D Walker
5Trisha E West
6Sam A Adams


Community examples


See also

transformations/enumerategroups.txt · Last modified: 2021/07/19 02:26 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki