Compare two excel sheets and get the matched and unmatched data

1154 31-05-22-test.xlsx (9.3 KB)
matched data.xlsx (9.7 KB)

My question is
Check customer ID from matched data file is available in 1154 test file or not by copy customer id one by one of matched data and filter on related_party_custid column in 1154 test file with that customer id, if it’s not present in the file will update that file into new excel file

If one related party cust ID is mapped to multiple Customer ID in matched data then multiple time details to be plotted in template file. In case same name is coming multiple times in 1154 test file with same main entity then it has to be considered only once for preparing letter

How to do this?

Hello @lokeshkumar.k

Please check the below video.


Hello @lokeshkumar.k

To get matched records :

inputDT1.AsEnumerable().Where(Function(row) inputDT2.AsEnumerable().Select(function(r) r(“ColumnName”).ToString).Any(Function(x) x = row(“ColumnName”).ToString)).CopyToDataTable

To get un matched records :

inputDT1.AsEnumerable().Where(function(row) Not inputDT2.AsEnumerable().Select(function(r) r(“ColumnName”).ToString).Any(function(x) x = row(“ColumnName”).ToString)).CopyToDataTable()