Blue Prism Product

 View Only
last person joined: 18 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  Filter collection on two columns

    Posted 06-30-2020 08:04
    Hi All,

    Is it possible to apply filter on a collection on two different coulmns at the same time using the single query. I have to filter one column & based on those results i want to filter another column, just like how we do manually in an excel. Is it possible via single query or I need to perform it in two different steps.

    ------------------------------
    sapna soni
    .
    Capgemini Pvt Ltd
    Asia/Kolkata
    ------------------------------


  • 2.  RE: Filter collection on two columns

    Posted 06-30-2020 08:35
    Hi Sapna,
    You can filter them using a single action using the AND Operator

    "[Column1] Like 'Criteria1' AND [Column2] Like 'Criteria2'"

    ------------------------------
    Rajath Gopal
    Associate IT Consultant
    ITC Infotech
    Asia/Kolkata
    8904867411
    ------------------------------



  • 3.  RE: Filter collection on two columns

    Posted 07-10-2020 20:34
    How would you achieve the same thing for the Sort action within a Collection?  The AND does not work.  Similarly to Excel I want to sort my collection by 3 different tiers.

    ------------------------------
    Jenna Schnizlein
    ------------------------------



  • 4.  RE: Filter collection on two columns

    Posted 07-13-2020 07:05
    Hi Jenna,

    For sorting collection with any number of tiers, you can use below expression.
    "[Field1]='Value' AND [Field2]='Value' AND [Field3]='Value'"
    (Note: If space exists in any column name you need to use [ ] to sort correctly).

    You can include 'n' number of different fields to sorting values.

    Please let me know if you are not clear.

    Regards,

    ------------------------------
    Yeswa Vaibhav Alwar Nerella
    Associate Consultant
    Capgemini
    Asia/Kolkata
    ------------------------------



  • 5.  RE: Filter collection on two columns

    Posted 07-13-2020 13:42
    Thanks, but that didn't work for me in the Sort Collection option.  However, I did figure out that if you just separate them by commas that works perfectly.  (Field 1, Field 2, Field 3)

    ------------------------------
    Jenna Schnizlein
    ------------------------------



  • 6.  RE: Filter collection on two columns

    Posted 07-13-2020 17:57
    @Jenna Schnizlein Thank you for mentioning the use of Sort Collection to sort multiple fields. I have always simply used the Sort Collection action multiple times in a row to achieve the same thing by sorting on Field 3, then Field 2, then Field 1 which gives the same results (despite that everyone argues with me to the contrary lol)​.

    Anyway, I should have known that was a thing. I just never tried it. Thanks!

    ------------------------------
    Dave Morris
    Cano Ai
    Atlanta, GA
    ------------------------------



  • 7.  RE: Filter collection on two columns

    Posted 07-14-2020 11:51
    @Dave Morris I thought about doing that, but couldn't figure out how to do it within the same action and if I just but them in order at the component level, it would just mess things up.  Luckily Google suggested this route for me.  I'm still relatively new to RPA, and finding these "simple" actions is proving to be more difficult than I would think.  I'm glad this forum exists now, I'm sure I will find myself relying on it more often.

    I would be interested to hear about how you got the multiple sort actions to work properly.  I'm not sure how to message you directly though, so that we can breakout that conversation.​

    ------------------------------
    Jenna Schnizlein
    ------------------------------



  • 8.  RE: Filter collection on two columns
    Best Answer

    Posted 07-14-2020 23:47
    But, @Jenna Schnizlein, it's a no-node platform that just anyone can pick up in a matter of hours! Hahahaha! Just kidding. There's a lot to know about even calling just the basic actions, primarily because the VBOs are just using methods from Microsoft's .NET Library. If I had looked up the code the action was using, it might have been obvious to me, but I'm lazy so I didn't. =)

    So, for the multiple sort actions... I think we're talking about the same thing here. If we're not, then I'll take it all back! =) Anyway, if you were trying to sort on 3 columns of a collection, you produce the same end result by sorting the collection 3 separate times but in reverse order. So, you could compare it to an Excel sort on multiple columns. There, you might tell Excel that you want to sort on multiple columns in this order: Field1, Field2, Field3. It would put alphabetical/numerical order preference on Field1, and then the next preference/sort on Field2, and then the next on Field3. In Blue Prism, if you were to do the same thing by sorting on Field1 then Field2 then Field3 with three separate action calls to Sort Collection, it would mess up your results. You'd just need to reverse it. So you sort by Field3 then Field2 then Field1, and you get the same results as if you were to use the way you found by doing Sort Collection with a field input of 'Field1,Field2,Field3'.

    ------------------------------
    Dave Morris
    Cano Ai
    Atlanta, GA
    ------------------------------



  • 9.  RE: Filter collection on two columns

    Posted 10-27-2022 13:18
    Hi @Jenna Schnizlein , Could you pls guide me how to Sort Collection for Multiple conditions. For Example Filed1 needs to be Sorted as "Ascending" and Filed2 needs to be Sorted as "Descending" at once. I was able to achieve in Excel(which is called as Custom Sort). How to apply Custom Sorting in BP Collection?

    Any one can suggest here.

    Thanks​​

    ------------------------------
    vinod chinthakindi
    ------------------------------



  • 10.  RE: Filter collection on two columns

    Posted 06-30-2020 08:42
    Hi Sapna,

    We can filter multiple columns by adding the AND/OR between each selection Criteria.
    "[Col A] = 'Data1' AND [Col B] = 'Data2' "

    Regards,
    NP

    ------------------------------
    Nitin Prakash
    Associate Cunsultant
    Symphony Ventures
    Asia/Kolkata
    ------------------------------



Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research ProgramUpdates, Releases & Announcements

FAQs

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.