How to compare two data table and get the missing one

Help Activities
,
1

Hi everyone,
I want to compare two data table, dt 1 contains A,B,C,D values and dt 2 contains A,B,C values so we need to identify Missing values which is located in dt 1 suggest a logic for this.

2

Hi @Gopi_Krishna1

Can you try the below query

dt_filtered = (From row1 In dt1.AsEnumerable()
                  Where Not dt2.AsEnumerable().Any(Function(row2) row1("A").ToString = row2("A").ToString AndAlso
                                                     row1("B").ToString = row2("B").ToString AndAlso
                                                     row1("C").ToString = row2("C").ToString)
                  Select row1).CopyToDataTable()

Regards,

3

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