How to retain rows from Datatable which does not contain any of the variables in an array

we assume that multiple names are present as a flatten string, seperated by ", "

with some risk (e.g. wrong partial matches like Chris, Christian matching) we can do

Assign Activity
dtResult =
(From d1 in dt1.AsEnumerable
let an = d1(“Name”).toString.ToUpper.Trim
Where Not dt2.AsEnumerable.Any(Function (d2) d(“Name”).ToString.ToUpper.Contains(an))
Select r =d1).CopyToDataTable

we ommited the string.split as we did a String.Contains Method check

When we want to mitigate the risk of wrong part matches we can do

using a more strict regex pattern and Regex.IsMatch

Assign Activity
arrD2NamesSplits =

dt2.AsEnumerable.SelectMany(Function (x) x("Name").toString.Split(","c)).Select(Function (x) x.ToUpper.Trim).toArray

Assign Activity

(From d1 in dt1.AsEnumerable
let an = d1("Name").toString.ToUpper.Trim
Where Not arrD2NameSplits.Contains(an)
Select r =d1).CopyToDataTable

Handling empty filter result:
:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum