How to get only the unique record in Datatable

Help Studio
, ,
1

Hi, does anyone know how to get only the unique value in Datatable. For example, if the column School contains five rows
AA School
BB School
CC School
AA School
CC School
The datatable should return only BB School.

5

Hi @Dalaboomba

Can you try the below

DT.AsEnumerable().GroupBy(Function(row) row("School").ToString()).Where(Function(g) g.Count() = 1).Select(Function(g) g.Key).FirstOrDefault()

image
image947×515 19.2 KB

Regards,

6

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
7

It works perfect! Thank you so much!

1 Like
8

Use DT.defaultview.table(true,“ColumnName”)

Thank you!

9

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