Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Count regression cannot choose target variable

SamZhong
7 - Meteor

The field I want to set as target variable is converted to int16, filtered to non-negative values, but I still cannot select any field in this node. What am I missing?

 

SamZhong_0-1574721049167.png

 

SamZhong_1-1574721087516.png

SamZhong_2-1574721125430.png

4 REPLIES 4
LukeG
Alteryx Alumni (Retired)

Hi @SamZhong ,

 

Are you able to provide a sample of the data and the workflow so that I can attempt to troubleshoot on my end?

 

Happy to help! In the meantime, I'll attempt to find a solution online

 

Luke

SamZhong
7 - Meteor

Thank you so much @LukeG,

 

I've attached a sample workflow package.

 

RolandSchubert
16 - Nebula
16 - Nebula

Hi @SamZhong ,

 

it seems, field type conversion does not work properly. As Count Regression is only applicable to Byte and INT fields as a target variable, I've added a Multi-Field Formula tool to change the data type of the Casesn field to INT32 by ticking the "Change Output Type" box and using an explicit conversion (ToNumber) in the formula. Now it works fine, Casesn field is selectable. I've attached the modified workflow. 
In general, I would recommend to convert fields explicitly, if you want to use them for predictive tools. Hope this is helpful.

 

Best regards

 

Roland

SamZhong
7 - Meteor

Thank you Roland, this was helpful.

Labels