Filter out some data from excel

[Kuldeep_Pandey]

Hi team,
I have two sheets i want to match amount and date from another sheet and if rec was not found match then create one excel sheet of rec not found data

[Aakash_Singh_Rawat]

Hi @Kuldeep_Pandey,

1. Use 2 read range activity for both sheets lets say DT1 and DT2.
2. For each row in DT1, we will check for DT1’s data in DT2
   i) If condition: DT2.AsEnumerable.Any(Function(x) x(“DT2_Amount”).Equals(CurrentRow(“Amount”)) And x(“DT2_Date”).Equals(CurrentRow(“Date”)))
   Then do steps for you have matched data
   ii) Otherwise Append to another excel sheet.