We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

K-Centroids Cluster Analysis: No valid fields were selected

DaveF
Alteryx Alumni (Retired)
Created

K-Centroids Cluster Analysis: No valid fields were selected

 

When using the K-Centroids Cluster Analysis tool, you may see the following error message:

 

Tool #27: Tool #6: No valid fields were selected.
Tool #41: Tool #6: No valid fields were selected.

 

Environment

 

  • Product - Alteryx Designer Predictive Tools

 

Cause

 

The most common cause for this error message is:

  1. One of the fields selected has no statistical variance (all values are the same)
    • If this is the case, you will often see another error message stating: "One or more of the provided data columns has a single data value."

 

Solution

 

  1. Attach a Field Summary tool (Data Investigation) to the data you are sending into the K-Centroids Cluster Analysis tool
  2. Investigate the results to find any fields no variance

 

DaveF_0-1573573859001.png
Additional Resources
 
Comments
yclian
6 - Meteoroid

Thanks a lot. This solved my problem, I was trying to spot for NULL 'til I arrived at your solution here.