Alteryx Designer Desktop Discussions

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

Network Analysis Problem

hctlee0812
5 - Atom

 

 

Hi All,

 

Here is the example dataset (also attached):

Capture.JPGIf a set has any part in common, I want to add the parts of the set to the group.

 

The final group for would be:

1. a,b,c,d,e,f,g

2. z

3. y,u

 

I have tried joining the table with itself on part number then joining the output with the original table on set (Right_Set & Set) and then grouping by Set / (Right_Part). Then turning this into an iterative macro and batching records in to account for the actual data set has 3 million records and takes hours to do this (24+ hours).

 

Is there another approach to solve this problem? Using the Network Analysis tool? etc.

 

Best,

Henry

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

Hi!

 

Thankfully, this is waaaaaaaaaaaaaaaaaay simpler than you think.

 

There is a tool called the 'Make Group' tool that allows you to achieve this.

 

2019-04-25_17-36-12.png

 

Ben

hctlee0812
5 - Atom

Made me look like a fool !! HAHA

 

Thank you so much, Ben.. so much to learn .....

Labels
Top Solution Authors