I have a SQL query embedded in an Alteryx workflow. The query requires the user to enter a date as DD-MMM-YY (ex. 15-AUG-22). A sample from the query is below. "INSERT_DATE" should be replaced by "15-AUG-22", in this case. How can I have the workflow request the user input the day of their choosing to run the query?
and trunc(a.create_dt) >= 'INSERT_DATE'
Solved! Go to Solution.
Hi @JKrause,
You can use a Text Box or Date tools under the Interface Tools to capture user input and pass the value to your SQL query using a Dynamic Input tool.
Cheers,
Lelia