Alteryx Designer Desktop Discussions

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

Clustering

sarahwisneski
5 - Atom

I am doing a cluster analysis and I keep getting the error "Tool #27 Tool #6 Tool #41 No valid fields were selected. K-Centroids Cluster Analysis the R.exe exit code (1) indicated an error

 

I'm not sure what went wrong it is as I have checked to make sure there is variance in each of the columns already

4 REPLIES 4
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

Are all columns of the right type?  Any nulls or empty?

grazitti_sapna
17 - Castor

Hi @sarahwisneski 

 

The Most common cause is :

1) One of the fields selected has no statistical variance (all values are the same).

 

Solution :

 

1) Attach a field summary tool ( Data Investigation) to the data you are sending into the K-Centroids Cluster analysis tool & investigate the result to find any field with no variance.

 

 

Sapna Gupta
sarahwisneski
5 - Atom

Two of the columns ending up having a small variance compared to the other variables I was including in it, I ended up removing them and it worked!

grazitti_sapna
17 - Castor

Cool ! So if you find my solution useful , could you please mark it as the solution accepted.

Sapna Gupta
Labels