Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Grouping linked items

5 - Atom

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.



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!

8 - Asteroid

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.




5 - Atom

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