topic Re: Error in Stepwise in Alteryx Designer Desktop Discussions

Error in Stepwise

wmacooper4 — Thu, 24 May 2018 02:42:22 GMT

I get the error in the attached screen shot whenever I try to run stepwise. I checked and I don't have any missing values in my data.

How can I eliminate this error?

Thanks.

Re: Error in Stepwise

CristonS — Wed, 04 Jan 2017 19:53:17 GMT

Hi @wmacooper4,

The Stepwise tool requires 2 inputs - the output stream from a Count Regression, Gamma Regression, Linear Regression or Logistic Regression tool used to create the "maximal" model, and the same Alteryx data stream that was used to create the "maximal" model.

Based on the attached error, it appears that you are not entering a model object from the above named tools - unless there is one saved in your yxdb?

Please let us know, thanks.

Re: Error in Stepwise

wmacooper4 — Thu, 05 Jan 2017 20:57:34 GMT

I was trying to see if there was something wrong with the tool. When I attached a logistic regression tool, it seems to be stuck at 26% progress.

How long should it take to run? I typically have 25-30 predictor variables in my models.

Thanks.

Re: Error in Stepwise

CristonS — Thu, 05 Jan 2017 22:08:16 GMT

How long it takes to run depends on a lot of things - your machine specs, how many records you're running, as well as your data. If you let it run, how long does it take to complete?

Re: Error in Stepwise

RodL — Thu, 05 Jan 2017 22:25:07 GMT

@wmacooper4

As a comparative benchmark, I just happened to run a Stepwise on a Logistic Regression with 500K+ records and 27 variables.

It took about 1 1/2 hours for the process to finish.

That's with a 2.60 GHz machine with 16GB of RAM.

And keep in mind that the % progress will not change that much during the process.

Re: Error in Stepwise

wmacooper4 — Mon, 09 Jan 2017 14:14:07 GMT

Our system was down on Fri, that explains the delayed response.

I changed it to what you instructed me to do, and now I get a new error message. What does this mean?

Please see attachment.

Thanks.

Re: Error in Stepwise

CristonS — Mon, 09 Jan 2017 16:28:17 GMT

Hi @wmacooper4, is your Stepwise input the same Alteryx data stream that was used to create your "maximal" logistic model? The error indicates that it's different data. Thanks.

Re: Error in Stepwise

wmacooper4 — Mon, 09 Jan 2017 16:26:45 GMT

Ok, that explains it. Looks like I'll have to use something else to do stepwise.