In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
Top Solution Authors