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!
Solved! Go to Solution.
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
That's exactly what I was looking for. Thanks Carl!