How to get Unique value from a column without looping

[KumariYadav1]

Hi, i am little new to blue prism ,Please help me out with a situation
i will explain the situation .......
i have an excel file and in this i need to find the unique customer name and after getting that customer name i need the whole row for that particular customer name 
because i need the details of that customer to perform other operation. i want that row to get into collection nd then perform other needed operation
But i don't want to use loop for getting unique customer name as its taking so much of tym ,actually i have around 200 to 300 data in excel so iterating each row is time taking. I have tried looping 20 rows nd perform all opearation , for this it took around 13 min.
Please guide me as soon as possible.

------------------------------
Kumari Yadav
------------------------------

[SandeepSachdeva]

Hi Kumari Yadav,

Since you are not comfortable with coding and don't want to use loop as well, thus another method you can try is as follows. Although it can be modified as per the requirement and thus I am mentioning the basic layout.

1) You can record a macro in excel itself, which will dedupe the data, with the help of Remove Duplicates. It is very easy to do and you can easily find it on google as well. You can name the macro whatever you want.
2) Call out that macro by using excel VBO in blueprism.
3) Once macro executed, import the data into collection through excel vbo only.

It's very easy to use and don't require any coding knowledge. You can record a macro in a minute very easily,  if you do a search on google. 

I hope this would be of some help to you.

------------------------------
Sandeep Sachdeva
Automation Associate
S&PGlobal
Asia/Kolkata
------------------------------

[KumariYadav1]

thanks Sandeep but I have already proceeded on what Amlan has suggested the code just one issue i am getting there so i have asked for that so just waiting if he will reply on that.

------------------------------
Kumari Yadav
------------------------------

[_Amlansahoo]

Could you please attach some screenshots or some examples it's difficult for me to say anything without an example

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

[KumariYadav1]

yes, see the attachment.
here you can see that in output we are not getting anything and because of this we  are not  getting output collection.
i have provided screenshot of object studio also whatever i have done there so that it will be clear to you.
please have a look on it.
Thanks

------------------------------
Kumari Yadav
------------------------------

[_Amlansahoo · Accepted solution]

Have you changed the code to options to C# in initialize page? Also make sure the Column name you are passing is correct. But fto make it easy I have attached VBO here. Just import and use it.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

[KumariYadav1]

Thanks Amlan
its working ,you really helped me a lot .

------------------------------
Kumari Yadav
------------------------------

[_Amlansahoo]

I am glad it worked. Please reach out to me any doubt on Blue prism. I am happy to help and thanks for marking as Best answer.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------