Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Replace SQL string in all Input Data instances

6 - Meteoroid



I'm currently using Alteryx to automatically run 2 queries from Teradata and output them to Excel. I do this daily so every day I would go into the SQL code for each Input Data instance and update the date in the SQL code to the current date. is there a faster way of doing this manually? thanks. 

Alteryx Alumni (Retired)

You can also try using a Dynamic Input and enter your date in a text input. See attached (click the Edit button on the top left of the Dynamic Input and connect to your DB. The Select tool is optional, but you can change the date data type to a string if you need to. Alteryx's default date is yyyy-mm-dd. I didn't see any problems with the app, but maybe the Dynamic Input will work.

6 - Meteoroid

Hey Nick, I actually went back and redid my work flow using the same process that you provided and it worked! I'm not sure why it didn't work the first time around, but it's working perfectly now. thanks!