Category: Transform / Advanced

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.

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

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".

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

Source table:

Action parameters:

Column "Province" is selected

Result:

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

Source table:

Action parameters:

Column "FirstName" is selected

Results:

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

Column "FirstName" and "LastName" are selected

Results:

• Enumerate rows