In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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