Hi @Dinesh_Babu_S ,
Have a lot of ways to validation
with your eg: check file excel empty
→ you can try read range file to get data table, validate by row count
if count > 0 → file not empty
else ->empty file
Generally, you will have to do validations based on your projects requirements. Deciding whether to validate the transactions in dispatcher or performer is also something you would need to decide, but I’ve found that in most cases it’s simplest just to let most of the logic be within the Performer.
Here are some other validations that you may want to do in a dispatcher:
Check for file existence:
Make sure that the input file or folder exists.
you can use the File Exists activity to check for file existence
Check for file format:
Make sure that the input file is in the correct format. For example, if you are expecting an Excel file, make sure that the file extension is .xlsx
the Get File Extension activity to check for file format
Check for data completeness: Make sure that the input file contains all of the required data. For example, if you are expecting a CSV file with customer data, make sure that the file contains all of the required columns, such as customer name, email address, and shipping address.
You can use the Read Excel activity to read the data from an Excel file and check for data completeness and validity
It is important to note that validation is a critical part of any automation process. By validating the input data, you can help to prevent errors and ensure that your automation process runs smoothly.
Here you go for a template on dispatcher process
I find this video more relative to your query