Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

if File exists within last 7 days then execute the workflow else do not run the work flow

Samals
6 - Meteoroid

I have a workflow which takes the data from an existing file x in a directory. The file x is updated every monday or wednesday. I want to check that if the file is there within the last 7 days in the directory then the workflow should run if not then the work flow should not run. 

 

Thanks

2 REPLIES 2
patrick_digan
17 - Castor
17 - Castor

@Samals Have a look at the directory tool. You can specify the file name completely (or use a wildcard where appropriate if the file name changes) and it should bring in Date last modified as one of the fields. You can use a filter tool to check if it's less than 7 days old (something like DateTimeNow<DateTimeAdd([DateLastModified Field],7,"days") and connect a dynamic input to the true side of that filter.

 

Digan

Samals
6 - Meteoroid

Thanks Patrick that worked perfectly

Labels