In my workflow I get two columns from SQL statement in Input Data Tool (1) say, "Customer" and "Street". Customer has about 1,000 values and "Street" has about 1,000 values.
I want to be able to use these values for customer and street as a second Input Data Tool which has SQL statement
For example, the second SQL statement is
AND Customer IN
AND Street in
I want these two AND statements to be populated by values from the result of first Input Data Tool.
Is this something that can be done by Dynamic Input Tool?