Network Analysis Problem

[hctlee0812]

Hi All,

Here is the example dataset (also attached):

If 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

[BenMoss · Accepted solution]

Hi!

Thankfully, this is waaaaaaaaaaaaaaaaaay simpler than you think.

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

Ben

[hctlee0812]

Made me look like a fool !! HAHA

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