Model coefficients macro does not return any results

I am trying to extract Model Coefficients from a simple Logistic Regression for downstream calculations. I found Model Coefficient macro/tool. This tool has been installed to Alteryx Designer 11.0 and then used on the canvas. The Config window states that tool requires no configuration and does not accept any input or output connections. The tool is supposed to return a simple table of Variables and Coefficients. However, once the workflow is finished the macro itself (Beta icon in the attached screenshot) does not return any results. When I try to open the Macro and execute the workflow (Input - R code - Output) some results are being returned in the output, but they are completely irrelevant (not from my dataset). What am I missing?

Any thoughts or ideas how to tackle this.

MODEL_COEFFICIENTS.png

Predictive Analysis

Accepted answers

CristonS

Hi @azhaglov - Place the macro yxmc file in to this location:

C:\Program Files\Alteryx\R-3.3.2\Plugin\Macros\Predictive Tools

If you're using the non-Admin version, or if your installation was to a different location, you can find the location by right-clicking one of the standard predictive tools (like the Boosted Model) and opening as a macro. On the Workflow - Configuration> Workflow tab, the filepath will be specified.

All comments

CristonS

Hi @azhaglov - The Model Coefficients tool needs a model object from a Count, Gamma, Linear, or Logistic Regression model in order to extract the coefficients. Can you let me know where it says that it does not accept input or output connections?

When you run the macro as a workflow, it is using the text input from the Macro Input tool, so would not make sense in the context of your data. Connect the model object from your regression tool to the Model Coefficients macro, and you should see results that correspond to your model.

azhaglov

Hi CristonS!

Thanks for your clarification.

In contrast to any other Tool, this one does not offer incoming/outbound connections feature (has no green arrows on the left/right hand side of the icon). Also, when I open the context menu for the tool there's nothing allowing to build that connection. Automatic pop-ups in the proximity of Logistic Regression tool also do not work. The same is happening when I try to connect O output of the Logistic Regression to the Model Coefficient tool - no reaction. Perhaps, I am doing something wrong? The text input for macro as a workflow is not an option, I agree.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280