- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 05:03 AM
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
------------------------------
Answered! Go to Answer.
Helpful Answers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-06-21 06:05 AM
------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------
Amlan Sahoo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 06:17 AM
You can play this excel for a collection depending on the number of lines in this excel, and then you can use VBO Collection manipulation following this step by step here:
HOW TO USE FILTER ON A COLLECTION STAGE | Blue Prism Product
------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 07:55 AM
PFB Code it's very easy to use, It is C# code.
DataView view = new DataView(InputColl);
DataTable distinctValues = view.ToTable(true,(Input));
Output = distinctValues;
------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------
Amlan Sahoo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 09:51 AM
Can you tell me after getting this filtered value that is unique value from the column how to get the corresponding row for this unique value.
suppose in "customer name" column we applied filter and we get the unique customer name .but for this customer name we have other details also maintained in a row (for eg customer address , phone and many thing) so we want to fetch this whole row in a collection to perform other operation.
guide me on this.
------------------------------
Kumari Yadav
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 09:57 AM
It's upto your requirement.
------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------
Amlan Sahoo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 10:14 AM
But if you can provide me the code for same like for each unique customer name if we can get the corresponding rows also copied in the collection it will be really a great help.
thanks in advance.
------------------------------
Kumari Yadav
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 10:24 AM
DataTable distinctValues = view.ToTable(true,"Field1","Field2","Field3");
Output = distinctValues;
You cand keep on adding column Name that's not an issue
------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------
Amlan Sahoo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 12:45 PM
But if you can modify this code as per the VBO code i mean while adding in Blueprism code stage i know some more things will also get added but i am not sure how to do that.
"DataView view = new DataView(InputColl);
DataTable distinctValues = view.ToTable(true,(Input));
Output = distinctValues;"
can you plz do it
Thanks
------------------------------
Kumari Yadav
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 12:59 PM
The above code is for single input. So if you want multiple inputs then you have to add multiple inputs to your code stage start parameter and use it in code stage. Also in intialie page of object change the code options to C# by default it will be Visual Basics
DataView view = new DataView(InputColl);
DataTable distinctValues = view.ToTable(true,(Input),(inpu1),(input2));
Output = distinctValues;
------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------
Amlan Sahoo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-21 03:42 PM
i tried this but one issue i am getting ,actually i am not getting output row ,what you have showed in second screenshot.
so because of this i am not getting any output collection.
guide me on this!
------------------------------
Kumari Yadav
------------------------------
![](/skins/images/00449F6C28EB28929E0CA1E1C569D167/responsive_peak/images/icon_anonymous_message.png)