How can I change my query dinamically?

[sebenciven]

Good Morning.

This is my workflow project.

In input tool I do a query where:

SELECT * FROM TABLE

WHERE DATE='20220930'

Date value is a DEFAULT.

I use Dynamic Input to change a string of my query (specifically 20220930) and the text box Interface to allow to user to insert a Date. In my idea the Interface value must change the date (so I don't operate on workflow) but the output has always the 20220930 data.

Can anyone help me? 

Thanks!

[DavidSkaife · Accepted solution]

Hi @sebenciven 

Is there a particular reason you're using the Dynamic Input tool? You should be able to discard it and connect the action tool directly to the input tool, and update the date within that SQL statement, i've attached a screenshot of a similar example I've done using a control parameter:

[sebenciven]

Good Morning.

No there isn't a reason for that. I saw it on the community.

I would change the date in the input tool because the query SELCT * FROM TABLE is too heavy for Alteryx.

I'll try.

Thnaks a lot.