How to Compare two Columns of different excel

Help Activities
, ,
1

I have DT1 and DT2…DT1 has A,B,C and DT2 has A,B,C,D,E My Requirement is to find the Excess value D,E which is Present in DT2 but not in DT1

2

@Gopikrishna_S

you can use this dt2.AsEnumerable.Except(dt1.AsEnumerable,System.Data.DatarowComparer.Default).CopyToDataTable

cheers

3

How to do it for particular column in each DT

4

@Gopikrishna_S

if particular column then use this dt2.AsEnemrable.Select(function(x) x("ColumnName").ToString).ToArray.Except(dt1.AsEnemrable.Select(function(x) x("ColumnName").ToString).ToArray)

this will give you array of unmatched values

cheers