Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Grouping linked items

keith_wonghy
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.

 

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!

2 REPLIES 2
Brinker
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.

 

Best,

Carl

keith_wonghy
5 - Atom

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

Labels