Hey , @Ashutosh.Gupta Looks like these is what I want. Few questions still.
I am finding Row 1 from Excel on Website if it founds then process further if not then It is the failed .
Same way other conditions also if found and failed in the middle of the web process that is also failed.
So in this scenario , Do I need to use throw activity and catch block for the failed one ? Because I have to use IF condition to check some conditions if available , If available then matching the value ?
Yes. Inside every if condition you can add throw activity for failed situations. In case of failure, the transaction will automatically go to cache. Then it will update the failed DT and then proceed with the next transaction in the loop.
Add column to the excel file name as “Status”
Use “For each excel row” activity to Iterate the excel rows, fetch data and use data in the website.
If the data in the web is success then use “Write cell” activity to update the status as “Success” in the excel.
If the data in the web is failed then update the status as “Failed” in the excel.
After first For each row in excel activity add one more For each row excel activity to iterate the updated excel file.
Inside the loop take a “If” activity to check the status = failed then send a mail in the else block.