Make Group Tool

The Make Group tool takes data relationships and assembles the data into groups based on those relationships.

Configure the tool

1. 1st Key: Select a column from the input data stream.
2. 2nd Key: Select a column from the input data stream that directly relates to the 1st Key.

Make Group logic

Key_1	Key_2
X	A
Y	B
Z	A
B	X
L	M

Group A contains A, B, X, Y, Z because X=A, B=X, Z=A, and Y=B

L and M make their own group, L as they do not relate to the other values in Group A.

By this logic, the Make Group tool would assign the following groups:

Group	Key
A	A
A	B
A	X
A	Y
A	Z
L	L
L	M