To fix this, you need to use a block until done tool or the crew macro parallel block until done tool. This will stop Alteryx from trying to access both sheets at the same time.
Hi @johnnykoung,
There are a couple of ways to do this,
Method 1: You could take advantage of the batch output method at the bottom of the output tool. Select the checkbox "take file/table name from field" and choose "change file/table name" in the dropdown. Finally select the field you want to use as your sheet/tab name in the dropdown (i've chosen category in my example below). This will output the row of each unique category into a new tab (Office Supplies, Technology etc).
Workflow:
Excel File:
Method 2: You could use a block until done tool to only run one output tool at a time and take the sheet name from a field (i've created a custom sheet name in a formula tool)
If this solves your issue please mark the answer as correct, if not let me know! I've attached both methods for you to download if needed.
Regards,
Jonathan
I've used the Block Until Done tool before, and the workflow still generated errors when writing multiple sheets to one Excel file. One of the errors was "unable to create a backup copy of xyz.xlsx".
The only option that seems to work for me every time is to use a batch macro, plus a Wait a Second macro, to write different formats/schemas to multiple Sheets in one Excel file. But this method adds to the runtime, by using the Wait a Second macro.
 
Please consider adding a Like to this related idea: Enhance options for Excel output
Chris
