How to dynamically change a string for an InDB query

csh8428

I've read through the community and can't really find a solution.. or at least one I can understand and reverse-engineer to fit my use case; which is admittedly quite simple.

I have workflow that I change the "Begin Date" and "End Date" values when I run the workflow in designer desktop to  in the query using a text input tool and the dynamic input tool(screenshot). I do this because those fields exist MANY times in the query so I don't have to change the values in multiple places each time I need to change the dates.

I now need to do this via InDB tools because the data-set is so large. I can't seem to figure out how to do this using InDB tools instead of the regular direct connect tools. This will be run from the Alteryx designer and not as an end-user app, so really I just need to mimic the usual Text input tool to dynamic input tool, but do it using and InDB tool.

I'm oversimplifying, but basically the query goes like this

SELECT 
NAME,
Begin Date,
End Date,

FROM HR_TABLE

WHERE 1=1
AND Begin Date = '0000-00-00'
AND End Date = '999-99-99'

This is how I do it using regular tools. How do I do the same using InDB tools?

Thanks for any help!

Craig

EDIT: Completely re-wrote the post to make it more clear

csh8428

I figured it out.

Create the fields as a formula you need to dynamically change. Also as a formula(after the dynamic formula) create 2 fields(either as a text input or from other parts of the workflow). One column contains the alias of the InDb connection and the other contains the SQL query. Now, IN the SQL query formula is where you enter the actual fields from the dynamic formula that you want changed.

After these formulas, then add a select tool where ONLY the connection and query columns are passed to the In-DB dynamic input tool.