Free Trial

Alteryx Designer Desktop Discussions

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

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

sics73
5 - Atom
 

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?

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

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
5 - Atom

thanks Luke_C,

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

Labels
Top Solution Authors