SOLVED
Create Excel with tab names from output
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rajtilak
5 - Atom
‎06-19-2018
01:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
- Dynamic Processing
1 REPLY 1
ACE Emeritus
‎06-19-2018
01:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
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
