I am trying to run a linear regression. I dropped the data in the canvas and I can see the data loaded successfully but when I try to run a regression the dropdown menu for target variable is blank. what am I doing wrong?
Hi @PaoloP
Would you please check the data type of your target variable?
You can drop a select tool between your input and the linear regression to change the type to numeric if need be.
Cheers!
Yes it is numeric. I dropped the select tool and it says the "Type" of each variable is "V_String"
Can you share a sample data about 10 rows would do. Just to build the workflow
Hello @PaoloP
Alteryx imports all variables coming from a csv file as strings by default, but the Linear Regression tool only accepts numerical values as a target variable.
As mentioned by @christine_assaad ,you can use a Select tool before the Regression tool and manually change each variable type or you could try an Auto Field tool (example workflow attached), which does the job automatically, then you´ll be able to choose the target:
Hope it helps
Regards