Grouping linked items

[keith_wonghy]

I have a table of item pairs where the 2 items in a row are linked to each other.
I want to group these items so that any items that are linked (directly and indirectly) are in the same group.

Example:

person1 | person2
-----------+------------
john       | george
george   | paul
george   | ringo
ringo      | paul
paul       |          <- it is sometimes possible that only one item appears in a row
kurt        | krist
dave      | krist
pat         | dave
chris      | dave
chris      | nate

Result that I'm hoping to have:

person  | group

----------+----------
john      | 1
george  | 1
paul      | 1
ringo     | 1
kurt       | 2
krist       | 2
dave     | 2
pat        | 2
chris     | 2
nate      | 2

The above table is full list of unique items and their respective arbitrary group IDs.

I'm pretty new to Alteryx and have been cracking my brains trying to figure out a way to to this but I don't even know how to start.
Your help is much appreciated!

[Brinker · Accepted solution]

Hi @keith_wonghy 

Try opening the example of the "Make a Group" tool under the join tab. Not sure if that is what you are after.

Best,

Carl

[keith_wonghy]

That's exactly what I was looking for. Thanks Carl!