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

Question

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 · Answer

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