question on Field Summary Tool outputs

Question

product documentation shows the following:

* O: An Alteryx data stream with descriptive statistics for selected columns along with recommendations, in the Remarks column, for managing data.
* R: A static report with a scatterplot and descriptive statistics for selected columns along with recommendations (see Remarks) for managing data in a column. To view the report, add a Browse tool and connect it to the R output. See Browse Tool.
* I: An interactive dashboard consisting of expandable panels for each column. To view the report, add a Browse tool and connect it to the I output. See Browse Tool. Each panel consists of a histogram or column chart and summary statistics:

Is is possible to OUTPUT the R and I results to Excel or is it only possible to view the results from within Alteryx?

Thanks!

Steve

dataMack · Accepted Answer

R and I are created from the data in O but its done internally with Alteryx's reporting tool and with D3 (i believe) for the interactive version.  You cant directly output that to Excel.

I assume what you are trying to do is have an excel file with charts and such?  Since the Field Info tool has a predictable output format, you could create a Excel template with a 'data' tab and then charts and pivot tables on a summary tab.  Then just write the 'O' output of the field summary tool in Alteryx to your data tab and your charts in excel would automatically refresh.

It's be a little bit of work to setup the template the first time, but you get the benefit of having it custom to what you want, and then it's automated from that point on.