Filtering big data tables

[Yoichi]

Hi,

Can you try the following sample?

dtKeep = dt2.AsEnumerable.Where(Function(r) dt1.AsEnumerable.Select(Function(r2) r2("Filtering Column").ToString).Contains(r("NoDoc").ToString)).CopyToDataTable()

dtRemove = dt2.AsEnumerable.Where(Function(r) not dt1.AsEnumerable.Select(Function(r2) r2("Filtering Column").ToString).Contains(r("NoDoc").ToString)).CopyToDataTable()

Sample20211228-a1.zip (18.2 KB)

Note : This workflow outputs 2 datatable : one is to keep record which exists in table1, another is to remove record which exists in table1.

Hope this helps you.

Regards,