Network Analysis Problem
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Made me look like a fool !! HAHA
Thank you so much, Ben.. so much to learn .....
