Compare Two Data Table and find Only the UnMatch Column

[Anil_G (Anil Gorthi)]

@marina.dutta

Can you try this

dt1.AsEnumerable.Select(function(x) dt3.Clone.LoadDataRow({x("Quote Number").ToString,String.Join(",",dt2.AsEnumerable.First(function(y) y("Quote Number").ToString.Equals(x("Quote Number").ToString)).ItemArray.Where(function(y,i) Not y.ToString.Equals(x(i).ToString)))},False)).CopyToDataTable

dt3 should be two columns or string type…use build data table and build it…gives you the quote number and corresponding mismatched values

cheers