How to get Not Matched Items from pimary table

Help Activities
, , ,
1

hello folks ,
I want get Not Matched rows from Secondary Tables i.e rows that are not in the Primary table. For Example i have Two Tables Dt1 primary table And Dt2 Secondary:-
INPUT
image
image

Output:
image

2

Assign Activity

dt3 =

(From d in dt2.AsEnumerable()
Let cv = d(0).toString.Trim
Let chk = dt1.AsEnumerable.Any(function(x) x(0).toString.trim.equals(cv))
Where Not chk
Select r=d).copytodatatable
3

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