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?
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
thanks Luke_C,
dynamic input + batch macro (to loop through each value) is my thoughts.