How to compare 2 different data table and create new data table with mismatch values

[Akhil_Raveendran (Akhil)]

i want to compare 2 data table having different column name

using values in column A and F and need matching values in one DT and mismatching values in another DT

pls help

[ppr (Peter Preuss)]

@Akhil_Raveendran

matching values in one DT

the entire dt1 rows or only the dt1 column A values?

[Akhil_Raveendran (Akhil)]

entire DT1 values with respect to column A, i mean i need entire data from table2 ,except column f value is 1 and 4.

[ppr (Peter Preuss)]

not clear your feedback. Just setup the expected output samples. We can faster suggest a solution approach based on this. Thanks

[Akhil_Raveendran (Akhil)]

[ppr (Peter Preuss)]

One of several options: LINQ Any Approach

Assign Activity
LHS: dtNotMatching
RHS:

(From d2 in dt2.AsEnumerable
Where Not dt1.AsEnumerable.Any(Function (d1) d1("A").toString.Trim.Equals(d2("f").toString.Trim))
Select r = d2).CopyToDataTable

Assign Activity
LHS: dtMatching
RHS:

(From d2 in dt2.AsEnumerable
Where dt1.AsEnumerable.Any(Function (d1) d1("A").toString.Trim.Equals(d2("f").toString.Trim))
Select r = d2).CopyToDataTable