Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Principal Components tool.

Tangchi
5 - Atom

Hello,

Please I need help. I am trying to apply PCA to a Diabetes dataset. So  I attached the Principal components tool to a pre-processed(Cleaned Dataset).

But when I do that, the fields in the dataset do not appear at the left "Fields column".

 

Please how Can I resolve the problem?

 

Thank you

PXL_20210620_091312071.jpg

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @Tangchi,

 

I believe your data is in string format. Please change it to numeric format and it will work like a dream! 

DawnDuong
13 - Pulsar
13 - Pulsar

hi @Tangchi 

For PCA, you need at least 2 numeric columns from the incoming dataset for it to work. The issue is because no numeric data is detected (Your top left corner is blank). You need to put a SELECT tool right after the INPUT tool to set the appropriate data types. Sometimes you can use the AUTO FIELD tool as well, but I'd recommend to visually inspect just to be safe.

The interactive training on PCA is very useful:

https://community.alteryx.com/t5/Interactive-Lessons/Principal-Component-Analysis/ta-p/679568#done

Dawn.

Labels