shaleeka
(shaleekareddy)
February 13, 2019, 6:27am
1
Hi All,
I have compared 2 different columns of 2 excel sheets and able to extract the matched values in those columns,but how to extract the entire row of the matched part of the column.
Thanks.
anmolk171
(Anmol Kumar)
February 13, 2019, 6:31am
2
Hi @shaleeka ,
Just go though this link.
You will find the answer
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…
Thanks!
Anmol
system
(system)
Closed
February 18, 2019, 7:45am
3
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.