Create Excel with tab names from output

[rajtilak]

I have a workflow which generates a list of country names from a dataset. I want the output tool to create a single file with tab names as those country names. When I am trying to achieve this using the output tool, it is also adding the tab name as a data in each of those sheets.

[BenMoss · Accepted solution]

Hi!

This is possible with the options available at the bottom of the output data tool.

Check the option to 'change table/filename from field

Choose your field.

Then with an excel file, to change the sheet choose the third option which is along the lines of change entire table name. This changes the sheet name when it is an excel file.

Then in order to remove your field make sure to change the option regarding keeping the field in the output.

Ben