Combining Spreadsheets
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
jmgutierrez333
5 - Atom
‎02-27-2025
01:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How can I combine multiple excel spreadsheets into one, but I want each spreadsheet to be its own tab within the joined spreadsheet.
Labels:
- Labels:
- Optimization
3 REPLIES 3
18 - Pollux
‎02-27-2025
01:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you can output to multiple Output Data tools - some will be the individual tabs and one can be the combined version!
‎02-27-2025
02:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried that, I transformed the data how I needed it then added multiple outflows for each of the spreadsheets and gave each outflow its own tab name and I just get errors saying it can't open the file to write.
18 - Pollux
‎02-27-2025
02:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you use control containers then? https://community.alteryx.com/t5/Engine-Works/Control-Containers-Take-Control-of-Your-Workflow/ba-p/...
