Below is how I have setup the control -
1. Base directory - <Some directory>
2. Includes - *.txt
3. Extract tab - I am extracting FileID and FileName using @filename function
4. Validate tab -
- Validate When - Always
- Validation Check Rule - Using t_contains function to cross check the file name
- When Pass - Invoke subsequent control
- When Failed - I have attached a result which triggers "file not arrived" notification to my email inbox.
Problem Statement - If the base directory has 5 files and the file which I am validating in step 2 above is not present then the 4 notifications are generated stating "file not arrived" and has names of files which are present in the base directory. I have attached a screenshot for better understanding.
Attached files
result_template.JPG
result.JPG
assure_file_monitor.JPG