Free Trial

Alteryx Designer Desktop Discussions

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

File Modified Date Notification

RDF25087
8 - Asteroid

Hi -

 

I'm looking for a workflow that looks at the last modified date of a file and notifies me by email if it is the same date as the last time the workflow was ran.

 

I probably haven't explained that very well....

 

I have a file on a network drive that should be updated every week. I need a fail safe that notifies me if that file hasn't been updated.

 

Any ideas?

 

Thanks

RDF

1 REPLY 1
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @RDF25087 ,

 

Directory tool gives you the file information of a directory.

If you run the workflow every day, you can filter the file with the Last Write Time is after yesterday.

Then you can make it to a Table and send as Email.

 

Workflow

Yoshiro_Fujimori_0-1683197591769.png

 

Formula in Filter tool

[LastWriteTime] >= DateTimeAdd(DateTimeNow(),-1,"day")

 

Table output

Yoshiro_Fujimori_1-1683197814355.png

 

I hope this may be of some help.

Labels
Top Solution Authors