{{ transformations:EnumerateGroupsAction.png}}
====== 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=====
This action 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=====
 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 constitute the "groups".

\\ 
=====Examples=====

====Example #1====
>Enumerate groups based on the values in the "Province" column.

===Before (source table)===
^Province  ^Amount  ^Total Tax  ^
|  ON  | 	1000| 	 125|
|  ON  | 	1500|	 187.5|
|  QC  |    	2000|	270|

===After (result table)===
^GroupNo ^Province  ^Amount  ^Total Tax  ^
|  **1**|  ON  | 	1000| 	 125|
|  **1**|  ON  | 	1500|	 187.5|
|  **2**|  QC  |    2000|	270|

===Action parameters:===
> Column: Province

\\ 
====Example 2====
>Generate group numbers from the values in the selected columns.

===Before (source table)===
^FirstName  ^Middle Init ^LastName ^
|Mary |K |Jones |
|Sam |A |Walker |
|Mary |M |Doe |
|Reggie |B |Monroe |
|Sam |D |Walker |
|Mary |K |Doe |

===After (result table)===
^GroupNo ^FirstName  ^Middle Init ^LastName ^
|  **1**|Mary |K |Jones |
|  **1**|Mary |M |Doe |
|  **1**|Sam |A |Walker |
|  **2**|Sam |D |Walker |
|  **2**|Mary |M |Doe |
|  **1**|Reggie |B |Monroe |

===Action parameters===
> Columns: FirstName, LastName

\\ 
=====Community examples=====
  * [[https://community.easymorph.com/t//1652/2|Which technique for grouping many columns of data together (i.e. 50+ columns)]] ([[https://community.easymorph.com/uploads/short-url/ub3zV5WsGF4rWqJQMb7oEtPReqy.morph|Project]]; Module: //Main//; Group: //Tab 1//;\\ Table: //Enumerate groups//; Action position: //2//)
  * [[https://community.easymorph.com/t//1837/4|Joining different pairs of value equivalences into “global equivalences”]] ([[https://community.easymorph.com/uploads/short-url/1TpBXIjf6r4auDHlOBejKh2rSTw.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Make up//;\\ Action position: //2//)

\\ 
=====See also=====
  * [[transformations:enumerate|Enumerate rows]]