How to remove these

in Addition to above, when the datatable has more columns but we have to check only on column, it can be modelled as a isMatch case, without for each loop modelling:

  • read range excel1 out: datatable - dt1
  • read range excel1 out: datatable - dt2

Assign activity:
dtResult =

(From d in dt1.AsEnumerable
Let c = d("Column1").toString.Trim
Where Not dt2.AsEnumerable.Any(Function (x) x("Column1").toString.Trim.Equals(c))
Select r = d).CopytoDataTable

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

2 Likes