How to automate a workflow to stop continue running if a pre-defined condition is met.

[michaeljlam]

Trying to create a workflow that only process the latest file from a shared drive and will gracefully terminate the workflow if no new file is detected instead of throwing a run failure notification email that filled up the inbox and panic everyone.

*Note: the LatestFileCheck is a processed file directory contains output with the same filename as in the non-processed group directory. 

Thanks,

[ddiesel]

Hi @michaeljlam !

I have a very similar process. Here's what works for us:

• Join on the filename
• New filenames come out Join Tool - L Anchor
• Processing continues from the L Anchor
• If there are no new files, 0 records are passed to the L Anchor and the workflow completes gracefully with no errors.

Instead of placing an error on every run with no new file detected, we place a DateTime threshold on the last file in the main directory. If a new file hasn't been received in x hours, then we trigger an email alert by failing the workflow in the Test Tool with a formula like DateTimeDiff(DateTimeNow(),[CreationTime],'hours')<x

Let us know if this helps.

Thanks,

Deb