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