unable to write to multiple sheets after join
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
lliberm1
7 - Meteor
‎12-04-2018
01:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Assume a workflow with a join that has two of the outputs proceeding in the workflow and ultimately writing to separate excel sheets in the same excel workbook. How is this able to be performed without error as it appears you can't incorporate a block until done tool on this split path.
I am currently having to add a formula to denote which sheet they would have gone to and union onto one sheet. See attached screenshot.
Labels:
- Labels:
- Error Message
2 REPLIES 2
17 - Castor
‎12-04-2018
01:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Duplicate the join tool and put the block until done in front of it, something like this
mmenth
11 - Bolide
‎12-04-2018
01:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can configure the output tool to write a new sheet for every status you have. Example:
