How to Stop Workflow if No new Input file is saved
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
skotian1289
8 - Asteroid
‎07-13-2021
10:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Database Connection
1 REPLY 1
22 - Nova
‎07-13-2021
11:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 : )
