I Want to Remove the Rows in DT1 which Containing the Value A and B which is present in DT2

Suggest a method to get appropriate output

your expecting the out is C AND D rows Right?


Yes that is the output I needed

Join Data Table (left) on the Name column with dt1 as left, dt2 as right. Then use Filter Data Table and remove rows where Name_1 is not empty and also to remove the Name_1 column.

Hi @Gopikrishna_S

Xaml : - macthing_columns dt1 and dt2.zip (2.3 KB)

you can try this link it will remove A B rows and give s the output as C D

(From row1 In dt1.AsEnumerable()
Where Not dt2.AsEnumerable().Any(Function(row2) row2(“Names”).ToString() = row1(“Names”).ToString())
Select row1).CopyToDataTable()

for reference you can see the output :-


Hello @Gopikrishna_S

dt.AsEnumerable.Where(Function(row) not dt2.AsEnumerable.Any(Function(r) r(0).ToString.Equals(row(0).ToString))).CopyToDataTable

It will helps!!!