Add new sheet to the same output file using Output tool

Question

Hi Team,

I'm trying to use 3 Output tool for 3 different input. the result will be produced in the same file but 3 different sheet. screenshot of the workflow attached. Getting error unable to open file. What is hat I'm missing. I cannot use render tool since it does not support more than 100k line items.

Appreciate any help

DataNath · Answer

No problem @hemant86! Ah yes, using that approach will work fine as long as the 3 schema are the same! :)

hemant86 · Answer

Thanks @DataNath . Wasn't aware of the parallel block tool. Will try that out. As of now I managed to do this using a 3 formula tools to add a SheetName column and 1 Union toll to combine all sheets to one file in the output tool.

DataNath · Answer

Hey @hemant86 the issue here is that your Block Until Done tools only act upon the individual streams and so all Join outputs will still be running and trying to output at the same time. When you want to set the order of multiple branches like this, you need to use the Parallel Block Until Done tool which is a Crew macro: http://www.chaosreignswithin.com/p/macros.html

Here you can see I set the order in which each output stream of the join actually goes through to the point of output, and in the end I can successfully write to all 3 sheets:

One thing to note here is that PBUD does not work with AMP enabled. If you're using the AMP engine, you can go into your workflow Runtime settings and untick 'Use AMP engine':

PBUD join outputs to 3 sheets.yxmd