Multiple process running same time but outputting to the same spreadsheet

[Taki]

Hi:

I am trying to run multiple process at the same time but want to output to the same excel spreadsheet with different tabs. I am getting an error when writing that the spreadsheet is being used by another process. Appreciate anyone who can show me how to do this.  Thanks,

[DavidP]

Have a look at the Block Until Done tool or the Parallel Block until Done from CReW macros

[Taki]

Will you be able to share how to use block until done in this example as I am new to Alteryx and was not able to figure out. Thanks

[DavidP]

If the data comes from the same 2 sources, you can do something like this

[DavidP]

If it's separate data streams for all joins it will be more something like this (with parallel block until done)

[Taki]

Thanks David. Can you let me know where the blocker with the 2 inputs is located. I only saw below from the developer ribbon. Look through all the other areas and was not able to locate the blocker with 2 inputs. They are parallel process that I am running. Thanks,

[DavidP]

It's called Parallel Block Until Done and it's part of the CreW macros pack. If you have it installed, it will come up if you type parallel in the search bar in the top right hand corner. As soon as you see it you can drag it from there onto your canvas. It;s the easiest way to find tools.

If you don't have he CreW macros installed, you can get them from here:  http://www.chaosreignswithin.com/p/macros.html

[Taki]

Thanks David. I downloaded the Macro and follow the samples provide but it only wrote to 1 sheet. It did not create the second and the third sheet. Appreciate if you can let me know what I am doing wrong.

[DavidP · Accepted solution]

Sorry, my mistake.

There's an error because your 1st parallel block until done only has 1 input, It needs 2 inputs at all times. The configuration should be as follows.

[Taki]

Perfect. Thank you very much.