Mechanics of Dynamic Input Tool

Question

I have a project when we need to read about 50 different SQL qyery syntax and run these queries one at a time and save the results to each file.

I thought of using workflows with Data Input Tool to read the data and then link to a batch macro.  Batch macro has Macro Input feeling to Dynamic Input tool control by Action Tool to run queries 1 at a time.

Well, that was the theory.  In reality, only the dummy query specified in Macro Input is running.  Data is NOT being passed from main work flow.

Any idea how we can fix this?

Thanks in advance for your help and guidance.

Carlithian · Answer

This can be done, as apathetichell says it would be helpful to see how you have configured the tool so we can see where the issue might be :)

apathetichell · Answer

Hey --- if you want help --- maybe post a screenshot of your workflow? maybe the action tool? maybe how replace a specific string is configured?

I personally don't touch dynamic input. I use dynamic input in-db. I batch my queries there. I like seeing what's going in --- so I use a text input tool. I also tend to use larger data sources/exports --- so I use push down queries.