Output Regression Coefficients/Residuals/Errors

[rahuls]

It would be great if we could output the coefficients of regression equation to a table so that one can use them in rest of the module. Currently, Alteryx can output the table/coefficients in charts/reports form which is not re-usable as such in the module. 
The values of coefficients/Residuals/Errors would be very useful in building macros for techniques like Missing Value Analysis which can't be done in Alteryx as of now.

[kane_glendenning]

I second this idea.

It would also assist in building SQL straight out of Alteryx if a Model then needed to be coded into a DB as a Stored Procedure. One example of this I've seen recently was a client who's DB was accessed through RDP as it was stored off-site at another company. Extracts were used for the Modelling, but he then wanted to code in the Model to have it run commonly on the whole Dataset.

[jeremy_dalletezze]

this post was very helpful in this context: 
https://alteryx-community.force.com/AlteryxArticle?id=kA0E00000000c1wKAA

[rahuls]

I tweaked the original Linear Regression macro a bit to output the coefficients. Anybody who needs a similar solution, please feel free to download the macro here.

After downloading the zip file, unpackage it and, just place the macro (Linear_Regression_Coefficients.yxmc) in the same folder as original regression macro, e.g.  C:\Program Files\Alteryx\R-3.1.2\Plugin\Macros\Predictive Tools\

And then restart the Alteryx Designer, the new macro will be in Predictive Tools.

[Ed_dup_96]

 Thanks is just what I've been needing.   Thanks