This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
Reject
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.
community Data Science Portal Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Discussions

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

Replace SQL string in all Input Data instances

asp_ty
6 - Meteoroid
‎09-19-2017 10:50 AM

Hi,

 

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. 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

11 REPLIES 11
JeremyG
Alteryx Alumni (Retired)
‎09-21-2017 08:12 AM

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.

sample 1.yxmd
Reply
asp_ty
6 - Meteoroid
‎09-21-2017 10:47 AM

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!

Reply
Labels