Group dataset into two clusters

[goutdelete]

Hi,

I have a big dataset where each unit I need to group the data into two clusters. Sample data as attached (as 1 unit).

Ideally the cluster should be determined by the long/ lat and closer points would be grouped together.

The problem is that in each unit, the # points of the smaller group are not identical.  Some are 1, some 2; in the sample there are 7 points. Does anyone know a tool in Alteryx that can easily perform this task?

Thanks!

p.s I put no base map on purpose so it's easier to see the two groups (clusters) in the dataset.

[caltang · Accepted solution]

You can try the K-Centroids Cluster Analysis tool:

[goutdelete]

Sorry I forgot to mention that my "units" can easily be up to 50K to 200K.

I was therefore not sure if using K-Means tool is the easiest (or efficient enough) even if I make a macro out of it..