pass each value from a list to variable then variable used in SQL query

[sics73]

hello team, I have a list contains different app names. For each value in the list, I need to pass this value to a variable which then used in sql statement. I need to loop through the list and append all SQL results to an output file.  the list will change depends on upstream process. It can be 1 row or 20 rows. Is iterative macros + drop down box the choice here?

[Luke_C · Accepted solution]

Hi @sics73 

You'll want to look at the dynamic input tool. You'll set up your SQL query in the dynamic input tool, then configure the 'Modify SQL Query' option to replace a specific string in your query, i.e. the App Name, with a field from your input data list. 

https://help.alteryx.com/current/en/designer/tools/developer/dynamic-input-tool.html

[sics73]

thanks Luke_C,

dynamic input + batch macro (to loop through each value) is my thoughts.