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