How to get only the unique record in Datatable

Assign Activity:
dtDeDup =

(From d in yourDTVar.AsEnumerable
Group d by k=d("SchoolColName").toString.Trim into grp=Group
Where grp.Count=1
Select r=grpFirst()).CopyToDataTable

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

1 Like