I want to compare two datatables

Help Activities
, ,
1

I want to compare two data tables where the matching columns were written into a new sheet and unmatched once on another sheet. the way matching in DT1 where columns(Withdrawal Amt., Deposit Amt.)Does any of the columns match the DT2 column(Amount in Local Currency). After that match the date columns and text columns then 3 are matched create a new sheet, and place the matched once otherwise it’s unmatched then create another sheet of unmatched once.
Attaching the sample Datatable below for the reference
Test.xlsx (9.8 KB)

2

Hi @Melbin_Antu

Your query is quite confusing. Could you be more specific…

If possible share the output file with us.

3

Here is the output file
Test.xlsx (11.5 KB)

4

i worked on the Foreach row in the data table but it took more time that’s why I need linq query or other method