Get the Matching rows When DT1 compared to DT2

[Yoichi]

Hi,

I don’t think Where is very slow. However double loop might be inefficient.
The following post is to leave mismatched rows using sort and single loop. This might help you.

Not getting expected output from Except function

Hi, If your data doesn’t contains tab (for example), can you try the following? [image] dt1 = dt1.AsEnumerable.OrderBy(Function(r) String.Join(chr(9),r.ItemArray)).CopyToDataTable dt2 = dt2.AsEnumerable.OrderBy(Function(r) String.Join(chr(9),r.ItemArray)).CopyToDataTable Dim idx1 As Int32 = dt1.Rows.Count-1 Dim idx2 As int32 = dt2.Rows.Count-1 While (idx1>=0 AndAlso idx2>=0) If (String.Join(chr(9),dt1.Rows(idx1).ItemArray)=String.Join(chr(9),dt2.Rows(idx2).ItemArray) ) dt1.Rows.Remove…

Regards,