I have two datatables. One with invoice information and the other is a blacklist with invoicenumbers. The last one only contains one column with the invoice numbers.
I would like to filter the first datatable, so only the rows with invoice numbers NOT present in the blacklist datatable.
I could do a for each row for the first dt and check if the invoice number value is equal to a for each on the blacklist, but that seems somewhat impractical.
So it is the one in the middle of the left side that i would like to do. Can i achieve this by putting it in an assign?