Block Until Done after Join

[Mike_at_CG]

Hi Community

Is someone able to assist with the below workflow I am trying to create?  The idea is to put left side join on 1 sheet, joined data on 2 sheet and right side join on 3 sheet.

I've seen videos of the parallel tool but my workflow is massive and am hoping not to have to create for all three sheets.

As always, any help is greatly appreciated.

Thank you

[Bren_Spill]

@Mike_at_CG - what version of Alteryx are you using? Control containers in v2023 could be a good route

[binuacs]

@Mike_at_CG try the below method

[Mike_at_CG]

Hi All  - tried the above and received and error that the file was already in use.

[binuacs]

@Mike_at_CG Can you keep the same Sheet1 in all the three output( highlighted below) and try again?

[Mike_at_CG]

Hey Binuacs - Confirming that the output files all have Sheet1 as the name.

[jdminton]

This should work. If it doesn't work for you, check to make sure you've added any patches for your Alteryx version. I had an issue with 2023.1 before I had it patched.

 

[binuacs · Accepted solution]

@Mike_at_CG try the updated version with block-until done tool

[Mike_at_CG]

Looks like this last one worked for me.  Thank you for the solution and thank you all for the input.

[jdminton]

You shouldn't need the wait a second tool to do this if you are patched.