Block until don tool is not waiting to execute inputdata nor outputdata tools

luisavilaBain

I have this issue when use this block until done tool, in my workflow need to fill 3 tables, 2 for master data and the 3rd table to be filled from the 2 master tables, but the 3rd input data that is a cross join from the 2 first tables is not waiting to finish to fill the first 2 tables.

as you can see in the log execution image first insert designation data table, then execute the select cross join after execute the insert function data table, but it supose that the select cross join should wait until the first two steps end before to execute the 3rd step, what can I do to force this wait until the first two steps ends?

csmith11

Right click your "3rd input data" tool and Convert it to a Dynamic Input Tool Instead.

You can then pass data through this tool like so:

For the Dynamic input tool choose the Modify SQL option. Click Add, then Choose "Replace a Specific String"

Set the Text to replace to blank. And Choose any field.

Please let me know if this solution works for you.