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