How to Compare Two Datatables

Will later in Production really only 1 Column be involved for the check?

  • Join DataTable activity and postprocessing the Join Result

LINQ - Match case

(From d in dt1.AsEnumerable
Let c1 = d(0).ToString.ToUpper.Trim
Let chk = dt2.AsEnumerable.Any(Function (d2) d2(0).toString.ToUpper.Trim.Equals()c1)
Where not chk
Select r = d).CopyToDataTable

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

we are using any and not where as we can faster stop when first time the condition has been met