Clustering

[FabioP]

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!

 

[OllieClarke · Accepted solution]

@FabioP 

Here's my approach with this:

It definitely works with your sample, and I think that it will scale, but test it on your actual data...