Need to Compare Two datatable columns and remove the rows

your case can be understood as a

  • Join DataTable case - then postprocessing the JoinResult
  • Match case

Match case:
Assign Activity
dtFiltered =

(From d in dt1.AsEnumerable
Let k = d("Column1").toString.Trim.ToUpper
Where Not dt2.AsEnumerable.Any(Function (d2) d2("Column1").toString.Trim.ToUpper.Equals(k))
Select r = d).CopyToDataTable

In case of an empty result is also to expect we can handle by: