How to Compare two data tables with specific Column data

[Yoichi]

Hi,

Can you try the following sample?

DT_Final = DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2("Phone").ToString=r("Phone Number").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Date","Phone Number","Currency"})

Sample20221123-2aL.zip (10.6 KB)

Regards,