Get only unique values from a column in excel

Help Studio
1

Hi ,
I have a requirement where I need to get distinct values based on specific column.

Can anyone help me on this

2

Hi @Robot_1
welcome to community

We can achieve this using linq

first of all use read range and store it in a datatable

next use assign activity and

DT=DT.defaultView.ToTable(true,“YourColumnName”)

If you make this false then it will display all the values from the datatable column.

Hope this helps

Thanks

1 Like
3

Please provide the data you have and the scenario you are using

4

Thanks let me try this

5

Sorry @aquinn data cannot be shared

6

Sure @Robot_1

7

Thanks it helped

8

Happy Automation :slight_smile:

9

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