We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Linear Regression outout problem

user345
6 - Meteoroid

Hi,

 

I have a problem when conducting the linear regression model. The report ouput didn't show me all the predictor variables I put in. For example, I choose one vairable that contains 3 category, but the output only show me two of them. I don't know whether it because Alteryx automately discounts values that have absolutely no significance? Could you help me with it? 

 

Thanks

11 REPLIES 11
IraWatt
17 - Castor
17 - Castor

Okay I've managed to replicate your problem. Essentially the linear regression tool in its default settings doesn't work with string/categorical variables they should all be numeric. 

Error from non numeric variables:

IraWatt_1-1650895136871.png

Only shows 2 of my 3 categories: 

 

IraWatt_0-1650895049168.png

 

What you need to do is one hot encode categorical variable before adding them to the model. This would mean having a column for each of your categories and inputting 1 for true and 0 for false if that row is that variable. 

IraWatt
17 - Castor
17 - Castor

@user345 Here is a link to a gallery tool which will automatically encode your categorical variables One-Hot Encoder - Alteryx Community

Labels
Top Solution Authors