How to Stop Workflow if No new Input file is saved

Question

Hello , I have built a workflow which reads a report generated on a daily basis and sends out email MIS for that specific report. These Reports are manually saved by our team in a shared folder before the scheduled run of Alteryx workflow. Each day reports will be saved and these reports will have specific run dates as their names example : XYZ 07142021.csv , XYZ 07132021.csv . There are times when team will either forget to save the latest report or for some reason latest report is not generated then the Alteryx workflow will pick up the yesterday's report and start sending out emails which becomes duplicate. Is there a way we can stop the workflow from running is no new Input files are saved In shared folder and instead Alteryx Workflow generating duplicate MIS of previous day report , can it generate an email saying "No New Report Found". Thanks SK

atcodedog05 · Answer

Hi @skotian1289

Here is how you can do it.

Workflow:

1. Configure Input tool to output filename as column.

2. Using formula tool extract date in the filename and check whether its today's date if yes than flag Is Latest 1 else flag Is Latest 0.

3. Using message tool if Is Latest is 0 (not latest) then show error message and stop execution.

Case 1: with the latest file.

Case 2: with the old file.

Hope this helps : )

latest file.yxmd

XYZ 07132021.csv

XYZ 07142021.csv