Read specific column in excel

Help Studio
,
1

how i get unique value from specific column.

ex: usr_name | location | value

    yogita       |  aumbai   |  xyz
    yogita       |  aune       |  pqr
   Akshay      |   aune      |   abc
    tanvi         |     tyffh      |   bc

read column usr_name &
output below:
usr_name
yogita
Akshay
tanvi

2

Hi @yogitagaikwad2206

Required from only one Column?

3

Hi @yogitagaikwad2206

Hoping that you have this data in a tabular format already,
if you have it then you can just filter dataTable Activity and
in the output Columns, select Keep and enter usr_name column in the input field below.
image

And then use Remove Duplicate Rows activity:
image

Thanks

Happy Automation!

4

@Yogita

Do something like this with the DataTable

image
image756Ă—447 18.8 KB

It will result into
image

Thanks

5

Read Range and Output will be dt_Input

Assign dt_Unique(Type DataTable) = dt_Input.DefaultView.ToTable(True,“usr_name”)

Hope it will help you…
Thank you…

1 Like
6

yes i want only unique name of usr_name column from excel

7

Read the excel using read range activity.

Once you have the datatable use the follwoing LINQ:

DT.AsEnumerable.Select(Function(r)r(“ColName”).ToString).Distinct.First

8

So to get only one column use Output from filter datatable activity and to get distinct values use linq i shared above.

Thanks.

9

can u send workflow of this i want type unique value in text box of usr_name one by one?

10

test12.xaml (10.3 KB)

11

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