How to Retrieve mismatching data from two datatable

How to Retrieve mismatching data from two datatable. Output should be same as in the attached photo

Mismatching table should have 3,4,5,6 in one column and C,D,E,F in another

Screenshot 2023-09-04 044052

Hi,

How about the following expression?

dtResult = dta.AsEnumerable.Except(dtB.AsEnumerable,DataRowComparer.Default).Union(dtB.AsEnumerable.Except(dtA.AsEnumerable,DataRowComparer.Default)).CopyToDataTable

Sample20230904-1L.zip (2.8 KB)

Regards,

1 Like

Resolved thanks a lot for the help @Yoichi

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.