Conditional row filtration

Hi I have problem to design solution for fallowing step:
I have two tables
T1 - Excluded and T2 - Numbers
T1 have one column named ToExclude
T2 have two columns: Number and Name

Now, If Number from T2 not match T1 Exclude value I want to copy this datarow to new datatable named Final

How can I do it?

For now i have this:

File with my idea to do so:
Filtrate.xaml (10.6 KB)
from this file:
LoadDTs.xaml (7.8 KB)

How can I do it?

Like this: (2,5 Ko)

Although, if you prefer the Linq query solution, @ppr will know a solution using Linq.


Thanks, I see that I overthink in my solution :wink:

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