Imagine a small set of data such as :
Set,ID
1,111
1,222
1,333
2,111
2,222
3,444
3,555
4,777
4,888
5,666
5,777
6,222
6,999
In this, set 1, 2 and 6 all share a common value or values (111 and 222 are in 1 and 2, and set 6 has 222). If i want any set with common values to become one set, how can i achieve this?
I started with an exact fuzzy match on the IDs, and then that gave me sets:
1 - 2
1 - 6
2 - 6 (4 and 5 come together as well)
Ok great, now I know that 1,2, and 6 should combine... and that's where I'm stuck.
Is there a better way? I'm not good with the multirow formula, but happy to learn if that's the case. If anyone could help that'd be great!
Solved! Go to Solution.
Hey @mzanier
What exactly do you mean by you want them to combine? Furthermore, how exactly do you want your records to look like once they combine?
An easy way to figure out if sets have common ID's is by using the CReW Macro Only Unique.
From here, you can use a Summarize tool to Group By ID and concatenate the Set field if that's what you're looking for.
Hi @mzanier, are you looking for something like the below? I basically took your dataset and parsed it using the text to columns tool delimiting on the comma.
Yes! This is exactly what I was looking for. Thank you!