Hello,
I got the following scenario (image attached), I'm working on a code/algorithm that help me to get the number of groups (3 in the example) in a matrix array, I dont know how to make it on alteryx.
The constraints are:
- To be considered a group the objects must match in 2 or more columns (example object 5 and 6 are no group with 7 and 8 becouse they only match on column 6)
- One object can only be part of only one group then it sould be discarded
- Object Ids and column names are unique
- There can be 0 to n number of groups
Thank you in advance!
