Alteryx Designer Desktop Discussions

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

Go to next to if

FMG
6 - Meteoroid

Hello,

 

I have a flow that has multiple Excel output files/sheets.  I want to update some of the files 3 times a day, others daily and some weekly.  Is there an easy way to skip some of the output tools depending on the day and time? 

 

Example: If sunday, output the weekly report to excel

                If any day between 10:30 and 10:45, run the daily report? 

 

Thanks

 

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus
If you don't mind a temp file being written, you can create a formula to write the proper file name when you want it and use a temp file name to write to (e.g. .\trash.xlsx) when you don't want it.
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Kenda
16 - Nebula
16 - Nebula

Could you add a Formula tool that checks your date conditions versus DateTimeNow() then use Detour tools to determine if output will get written or not?

FMG
6 - Meteoroid

I am not familiar with the Detour tool, but I think it could work with the tool DateTimeNow and filters. Thanks

Kenda
16 - Nebula
16 - Nebula

No problem! If you still can't get it to work, let me know and we can look into it more. 

Labels