Principal Component Analysis Error

[UKYstudent]

  

Hello Alteryx Community,

I am taking a data analysis class through my university so all in all, I have SUPER limited experience with this software. 

My issue is that the Principal Component tool is telling me that no valid fields were selected and the execution was halted. 

I have included the data set as well as the workflow. I would be more than happy to explain anything as well as provide any more information.

THANK YOU!

[RolandSchubert · Accepted solution]

Hi @UKYstudent ,

usually, errors thrown by any of the predictive tools are caused by input data (all the R based tools are very sensitive in terms of data types, NULL values).

You used an Impute tool to fill Null values for some fields, and it works fine for most of them - with the exception of "income". For this field, an additional field "income_" is returned, while the field "income" is NULL. These NULL values are handed over to PCA resulting in the error message you see, so the error is caused by the Imputation tool.

To avoid this, I've modified your workflow (added a Select tool to remove the field containing only NULL values and rename the "income_" field). Now it should work as expected. 

Let me know if it works for you now.

Best,

Roland

[UKYstudent]

Roland,

You are the man!! Thank you so much!