Hi,
I am having trouble achieving the results I need.
I want to create a Group ID based on two variables (ID#2 and ID#3). However, an entry may be considered apart of the same group if ID#2 falls within ID#3 or vice versa.
The example I've attached is incorrectly grouping all these values in separate Group IDs when I need all of the entries to be tagged as Group ID 126.
Thank you in advance for your help!
What is your grouping logic? I can't tell just by looking at your data.
Apologies for not being clear.
It might be easier to see with a smaller subset of data. From the screenshot below, I've highlighted IDs that should all be grouped together under Group ID 126 because they have a common variable present either under ID #2 or ID #3 (NSLP000003289).
However, the items highlighted in orange are being grouped incorrectly. The idea is if the ID exists within the ID #2 group or within the ID #3 group elsewhere, it should be included with the previously existing group.
Please let me know if there's anything else I can clarify. Thank you!!