Compare 2 datatables, write match to next column where they match

[Mulya_Habibi_Tullah]

Comapring multiple coulmns in Excel Files

Hi All, I have two Excel files Excel1: [image] Excel2: [image] I need to compare first two columns in both the sheets and if matched, update the third column in first sheet taking value from second sheet 3rd column. Also I want to validate if a cell in 1st sheet is empty then write a exception. Please help me friends. I have gone through many topics but can’t find the exact solution.

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…