Writing 2 sheets to the same Excel workbook

[jdallen75]

I've seen the Block Until Done tool used in the past to prioritize writing to an Excel workbook from 2 data streams, but I can't get this one to work.

As per this workflow:

I currently have one Block Until Done at point A, and I'm only getting the "Report" sheet created in the Excel, which is labelled under Primary Outputs beside B2. If I disable that container, the Formula Output will create a sheet called "Step 8 Formulae" beside B1, as desired. I'm just not able to populate the Excel with both sheets when both containers are enabled. What am I missing?

The Results table says both outputs are created and written, but only the Report sheet exists at the end:

Do I instead need to drop a Block Until Done at both points B1 and B2? I've read the documentation in Designer for Block Until Done, but there's no illustration, so I'm a bit confused on how to properly insert it into the workflow.

Thanks,

Jeff

[DataNath · Accepted solution]

Hey @jdallen75 - in your Output Data configuration, particularly the second one, is there any chance you have selected the output option to overwrite the file, rather than overwrite sheet or create new file or something? I ask because normally you’d get an error saying the file/process is already in use if it is as a timing issue due to the Block Until Done set up.

[jdallen75]

Thanks @DataNath ... I discovered this a few minutes ago, and that appears to be the issue - but couldn't find where/how to drop the posted question.