How to Output multiple files on same Excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Community - I'm trying to have multiple parallel processes output to the same excel file on different tabs. In order to let the cache flush each time it's written to, I put in a few "Block Until Done", but it's not working. Here is the flow. Any creative ideas other than setting up separate WFs and running one by one?
Thank you!
Daniele
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could potentially use control containers if you are on a current enough version to sequence parts of the workflow so that writing to each sheet of the same excel file can be done
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, yes, I have the latest version so I can use this feature. However not sure how I need to set up the containers to actually make it work. See below an example, I still get the error...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@daniele_zatti try setting up the Control Containers so that only the outputs are in them and staggered, like so:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you both!