How to cluster/group certain data in Alteryx

Question

Hi All,

I have a table which contains a list of items and value representing certain relation between those items. I would like to know if there is a way to generate n clusters (groups) based on such type of data.

The data below is just a small sample, but my real list contain over 100 items and 1400 associations and I would like to create for example 10 to 15 groups or clusters based on a specific value that associate the items.

Thank you in advance

andrefm · Answer

Thx dbmurray,

The result of your solution matches the solution what I was after, but this does not work in a larger dataset as it would group starting based on the finding and not necessary based on the value ("compatibility")

I came to this flow:

The idea I got from:

Comparing fields for similar data and group together

The output is not 100% matching what I described, but the flow works OK with a larger dataset which is what I was after.

Any other similar approach would be appreciated.

Thank you

Grouping.yxmd

dbmurray · Answer

Just wondering @andrefm - did that approach solve your problem? If so - it would be great if you could mark my post above as the solution. Thanks 🙂

dbmurray · Answer

Ok @andrefm , so I had a play with your data. It seems you also have a rule where you want to exclude any value <70 going by the highlighted table? If that is the case - I've filtered them out...the next step then is to use the MAKE GROUPS tool.

This creates groups similar to your expected output.

You can see A, B,F belong to group A, E and C belong to 'C' and D is in its own group.

You might have to have a play around with the tool and your larger dataset, but its fairly easy to config

make_groups.yxmd