Output results in a excel file but in separate spreadsheets

Hello,

I am trying to output the results in a single excel file but in separate spreadsheets.

I am using four Summarize tool to fetch the distinct count of four specific columns and then output it in a single excel file but in separate spreadsheets.

Please let me know how to achieve this. Thanks in advance!

Output

Accepted answers

DavidThorpe

Makes sense, please see the attached.

This version is set to 'Overwrite Sheet (drop)' In option 3 of the configuration options.

Hopefully this should work for you!

Multi Output v2.yxmd

All comments

DavidThorpe

Hi @Prashant_Raju

In the output tool, configure your excel output as usual.

At the bottom of the config pane for the output tool, select 'take file/table name from field', selecting your summarise field and choosing the drop-down to 'Change file/table name'.