Connecting input database to R Logistic Regression (or Linear Regression) Tool - only InDB

I can't seem to connect from an input source (alteryx db) to the R Logistic Regression Tool. The tool only seems to connect with InDB tools? I had to run my own logistic regression script using the R tool connected to my input data. I want to demo to other company users the use of the R Logistic regression tool itself.

Thanks.

Workflow

R Tool

Prescriptive Analytics

Accepted answers

mscuaycong

I was using the regular input tool (not the indb) (See Image below. The blue connector on the logit tool won't connect to the green connector on the input tool ). I noticed the Logit Reg tool says it's an indb tool. Anyway, I've solved this problem by looking at the macro behind it. It turns out that my workflow file has other indb tools that I've disabled within tool containers. The R Logit Reg tool automatically assumes I'm trying to connect to an indb tool when I am not. So, I opened a new workflow and dragged the same tool onto the canvas and this time, the R Logit Reg tool has a regular connection to the input tool. I was able to connect.

NeilR

As you've discovered, if any In-DB tools are on the canvas the Linear Regression tool (among others) will automatically convert to In-DB. To revert to non-In-DB, right-click on the tool and go to Choose Tool Version, see below...

All comments

JessicaS

Hi @mscuaycong,

Are you using a regular input tool or a connect in-db tool? If you are using a connect in db, try using a data stream out then connecting to the tool. Otherwise, you can connect to the same database using an input data tool.

Thanks,

mscuaycong

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703