Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Execute detour based on condition

neilgallen
12 - Quasar

Short question but I haven't seen a great solution anywhere in the world.

 

I have a workflow that runs daily with no issues. This gets manually executed daily around 9 AM EST. 

 

Once a month we need to execute this workflow at approximately midnight. There are portions of the workflow that do not need to be run, however and for runtime I'd like to avoid those sections.

 

I'm thinking a detour would be the best route for this, but I'm unsure of the mechanics to execute it based on the system clock. 

 

Any suggestions or reference materials are welcome.

4 REPLIES 4
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @neilgallen,

 

Could you not use a filter tool with the DateTimeStart() function? Use the true output anchor as the stream to include the process and the false to exclude the process rather than using a detour tool?

 

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

neilgallen
12 - Quasar

Could, however I want to completely avoid doing any data input if possible.

 

That's [one of] the most significant time consuming portions of the workflow and ideally I don't want to even waste the time inputting data that I'm not going to process.

Jonathan-Sherman
15 - Aurora
15 - Aurora

If you used the filter tool could you not combine it with a dynamic input tool so you're only loading the data in for the true output anchor?

 

Regards,

Jonathan

neilgallen
12 - Quasar

had not considered playing this with a dynamic input...that's a winner. Will need a bit of testing but I think that's the play.

Labels
Top Solution Authors