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.
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.