Linq Compare 2 Data Table and Join Result if ID Not Found

Help Activities
, ,
1

Hi All,

I want to compare 2 data tables and merge them into the datamaster if ID in Datatable 2 is not found in the DataMaster

Untitled
Untitled1059×664 13.2 KB

thankyou all

2

Assign Activity
dtResult = dtMaster.Copy

Assign Activity
dtDiff =

(From d in dt2.AsEnumerable
Let ids = d("ID").toString.Trim
Let chk = dt1.AsEnumerable.Any(Function (x) x("ID").toString.Trim.Equals(ids))
Where not chk
Select r =d).CopyToDataTable

Merge dataTable Activity: merge dtDiff into dtResult

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

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.