Distinct Value from Data table specific column

Help Activities
1

Hi,

I am not getting the desire result which fetching the distinct value from the data table based on one column below is the example.

IMG_20220517_173208
IMG_20220517_1732081920×876 135 KB

I want to get distinct data based on name col.

I have tried below

Dttest.defaultview.Totable(true,"id’,“name”,“course”)

Please help me in this

2

Assign Activity
LHS: dtCleansed | DataType: DataTable
RHS:

(From d in YourDataTableVar.AsEnumerable
Group d by k=d("Name").toString.Trim into grp=Group
Select r=grp.First()).CopyToDataTable
1 Like
3

Hi @Harbansh_Singh ,

It seems you are using id and course also

Have you tried Dttest.defaultview.Totable(true,“name”)

1 Like
4

Thanks @ppr it worked

5

Hi @Sam_Abraham with the given solution it will return only name column not I’d and Course

6

@ppr how can we group by 2 column
Need to write seperate group by clause for that column? It i want to include Course Column also in group by

7 
(From d in YourDataTableVar.AsEnumerable
Group d by k1=d("Name").toString.Trim, k2=d("Course").toString.Trim into grp=Group
Select r=grp.First()).CopyToDataTable

For more info on LINQ also have a look here:
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

2 Likes
8

Thanks you @ppr for the linq link

9

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