Exporting linear regression results to Excel

Hey all,

Can anyone help me on figuring out how to export linear regression results to Excel? I can see the correct table with the Browse tool (See pic below). However, i would want to export this table to Excel. If i use just the regular export tool or export data tool, i get just a string with the metadata of the table.

Thank you a lot!

Regression results.png

Predictive Analysis

Accepted answers

alexnajm

Sounds like you need a Render Tool (alteryx.com)!

All comments

alexnajm

Sounds like you need a Render Tool (alteryx.com)!

cyeager

Does anyone know how to automatically keep only the Variable names and coefficients from the model (section 7) within the workflow and keep it automated? Right now, I'd have to go to the temporarily saved Excel rendered sheet, and grab the data. Depending on the model it could be 3 to many more variables from the spreadsheet and manually paste it into a new worksheet. Thanks for your solution/ideas

cyeager

Ok, at least I can use Render to "Group Data Into Separate Reports" , to reference the "Coefficients" file and then use an input node to select Excel columns A:B to use in an input workflow. **A key is to within Render, drop down to in the Output Mode: "Choose a Specific Output File" first for "Group Data Into Separate Reports" to un-grey itself.**

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703