Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Dynamic Input

5 - Atom

I am trying to run a dynamic input with a modify SQL clause.  The Dynamic input is working great however, I am running into an issue with my workflow.  I have a list of vendor ID's that are connecting into my dynamic input that update the SQL Query.  Rather than running the SQL and completing the entire flow with that one query, it runs all of the vendor data at once and then finishes the workflow altogether, rather than running separately for each vendor.  


This doesn't work for me since I am trying to separate customers with filters and joins based on their shop year and for each specific vendor they are using.  


Is there any way to have the flow run completely through each time it runs a sql query in the dynamic input rather than it run in the input then finish the workflow all at once?

Alteryx Certified Partner

Hey @Dylan_Brown


Sounds like you may want to consider putting your dynamic input inside of a batch macro!


Here's a handy video to watch for your viewing pleasure:





Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

5 - Atom

I thought that might be the way to do it.  If I create a batch macro, how would I configure the tools?  For the dynamic input, would I need to use a macro input with the list of vendor id's for the input to read?