How to compare 2 datatable and remove data in 2nd table which are not matching?

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Vanitha_VS

Try with this

dt1.AsEnumerable.where(Function(r1) dt2.AsEnumerable.All(Function(r2)( (r2(“Name”) isnot r1(“Name”) )And (r2(“Salary”) isnot r1(“Salary”)) and (r2(“Email”) isnot r1(“Email”))))).ToArray.CopyToDataTable