Execute a DB query generated through formula

[Rayan]

I have a SQL query that has a date field which is dynamic. I modified the query using Formula tool. Now, the resulting output should be executed against a database. I cannot hard code the query in input tool. Is there a way for this? I am new to Alteryx and any help is much appreciated.

[BrandonB · Accepted solution]

You will want to either use a Dynamic Input tool (Developer category) or a Dynamic Input In-DB (In Database Category). Both of these tools allow you to dynamically change a query that is then executed based on what you are passing in. 

https://help.alteryx.com/20212/designer/dynamic-input-db-tool - In-DB version

https://help.alteryx.com/20212/designer/dynamic-input-tool  - In-Memory version

[Rayan]

I did try Dynamic Input, but couldn't get it working. Will take another shot. Thanks.

[JagdeeshN]

Hi @Rayan ,

Can you please elaborate on the error that you got while using the dynamic input tool. Also if possible can you share a screenshot of how you have configured that tool.

Best,

Jagdeesh

[mtouiti]

@Rayan , please make sure that the dynamic tool will only allow you to run Select queries. so no insert or updates. 

[mtouiti]

Here is another post on community regarding the same ask: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-updated-InDB-SQL/m-p/61484... 

[Rayan]

Appreciate support from everyone. Dynamic Input tool is the way to go. I'll explore In-Memory version further.