Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Block Until Done for Staging Table when there is an Output Table and an Input Table

BobbyQ
7 - Meteor

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

BobbyQ_0-1760391350292.png

 

2 REPLIES 2
BobbyQ
7 - Meteor

That is perfect! Thank you so much

Labels
Top Solution Authors