Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Cluster question - Counting Nodes and Labelling Clusters

AndyT_9976
5 - Atom

Sorry if this is simple but I'm still new to Alteryx.

 

I have two colums of observations with each record being a linked relationship - for the sake of clarity, we'll call them Employee and Manager. 

 

Many of the records are unique pairings, i.e. 1 employee to 1 Manager.  The rest are 1 to many, many to 1 or many to many. 

 

I need to label each cluster with a unique ID so I can consolidate them later but I also need to identify the number of nodes in the cluster so I can potentially exlcude outliers.

 

 

Any suggestions?

2 REPLIES 2
Aguisande
15 - Aurora
15 - Aurora

Hi Andy,

I'm not getting exactly what you need, (how you're clustering, the unique ID criteria, etc), but for what I read, the Make Groups Tools and/or the Tile Tool can help you get want you need. I'll try to put you on the right direction, with this simple sample:

 

emplo-manager-2.PNG

For the Make Groups Config:

emplo-manager-3.PNG

 

For the Tile Tool:

emplo-manager-4.PNG

 

Best,

_AG_

AndyT_9976
5 - Atom

Thank you - Group By worked perfectly. 

Labels