Maybe this is the wrong tool but I was thinking I need something to function similar to the Block Until Done tool. I have a Staging table that I am writing output to and need the second half of the workflow which brings in this staging table to not run until the staging table is finished.
The challenge is the Staging table is an Append and has some Post SQL on it to delete duplicate orders where there is a newer timestamp being created. Therefore it does need to output and then be brought back in to the workflow as the second half of the workflow doesnt have this timestamp limitation.
Is there a way to stop the Input table from running until and Output table in the workflow finishes? I highlighted the two tables in yellow below (the upper being the stage that needs to run first and the input table from that stage table below it). I put the Block Until Done tool in there only o realize you cant connect to an input table (duh). Any ideas or help would be greatly appreciated. Thank you
Solved! Go to Solution.
Use Control Containers! Available as of 2023.1: https://community.alteryx.com/t5/Engine-Works/Control-Containers-Take-Control-of-Your-Workflow/ba-p/...
That is perfect! Thank you so much