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
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:
Only shows 2 of my 3 categories:
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.
@user345 Here is a link to a gallery tool which will automatically encode your categorical variables One-Hot Encoder - Alteryx Community