-I have two data table DT1 and DT2, where I have to compare and get the mismatched records from both the data table.
-Have to compare with columnPayment reference in Ref.xlsx(excel sheet) with contains on column Trans Item in TransItem.xls(excel sheet)
-I am attaching a sample excel sheet.
In general, I am looking for 3 output:-
- Matched data.
2.Unmatched data(data present DT1 but not in DT2).
- Unmatched data(data present DT2 but not in DT1).