Filtering Datatable Column with another Datatable Multiple Columns with Linq

Hi,

Hope the following helps you.

dtResult = DT1.AsEnumerable.Where(Function(r) filteredDT2.AsEnumerable.Any(Function(r2) r("Vendor").ToString=r2("Vendor").ToString AndAlso  r("Document currency").ToString=r2("Document currency").ToString)).CopyToDataTable

Sample20210925-3.zip (7.9 KB)

Regards,

1 Like