Read specific column in excel

[yogitagaikwad2206]

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

[AutomationX_by_Kiran]

Hi @yogitagaikwad2206

Required from only one Column?

[adiijaiin (Aditya Jain)]

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.

And then use Remove Duplicate Rows activity:

Thanks

Happy Automation!

[argin.lerit]

@Yogita

Do something like this with the DataTable

It will result into

Thanks

[AutomationX_by_Kiran]

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…

[yogitagaikwad2206]

yes i want only unique name of usr_name column from excel

[prateek.mehandiratta9 (Prateek Mehandiratta)]

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

[prateek.mehandiratta9 (Prateek Mehandiratta)]

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

Thanks.

[yogitagaikwad2206]

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

[prateek.mehandiratta9 (Prateek Mehandiratta)]

test12.xaml (10.3 KB)