DataTable Comparison

[ui_dev]

I have 2 excel files and they stored as data tables. 1st excel file has columns (A,B,C) and 2nd excel file columns (D,E,F,G). I want to compare values of column A and column C to values of column E and column G. All the unmatched values should be stored in another data table. Any help is appreciated.

[aksh1yadav (AKSHAY YADAV)]

Hey @ui_dev

You can try this:-

Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records`

Hello Community Use Below Code to Compare 2 Datatable Column and Get Matched and Not Matched Records Note- Based on your datatable column datatype update datatype here with column field. To Get Matched Records Datatable Out_Matched_Data = In_DataTable1.AsEnumerable().Where(function(row) In_DataTable2.AsEnumerable().Select(function(r) r.Field(Of Int32)(In_DT2_ColName_To_Match.ToString)).Any(function(x) x = row.Field(Of Int32)(In_DT1_ColName_To_Match.ToString))).CopyToDataTable() To Get Not…

Regards…!!
Aksh