Sum the value and validate

Hello community friends,

My scenario is
I have two excel reports . i have to filter the first report based on two values and then check the date. I have to filter the second report using that same date and find all the values that i am getting after filtering. I have to validate those values one by one that whether they exist in the first report or not. If all of them exist then i have to sum them up and validate whether that sum value is present in the first report or not. How can i process this ?
Please suggest and help.

Thank you :slight_smile:

Hi @mannu.1996.08

use filterdatatable activity to filter both the excel files

then iterate the output datatable using for-each

inside the for each use if activity to check whether the row value present or not

Thanks,