Blue Prism Product

 View Only
last person joined: 13 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  Filter set value in different columns

    Posted 06-09-2022 13:09

    Hello masters and mistresses!


    I have a problem, well, I have a defined data called "material" and only the value called "center" is in the worksheet, example:

    Column C "Material" : "VALUE A", I need to check in column H to Z if it has the center "H001".



    The problem is that it is taking a long time and the process sometimes falls because the columns are big.

    I had seen something related a while ago here in the community but I couldn't find the topic, someone had made available a code in C# or VBO that helps with this issue.


    Can someone help me?

    Thanks



    ------------------------------
    José Francisco Bezerra Nunes Júnior
    ------------------------------


  • 2.  RE: Filter set value in different columns

    Posted 06-09-2022 13:43
    Hi Jose - you can apply a filter to  BP collection with the Utility - Collection Manipulation VBO. The filter expression would be something like
    [Material]='Valor A' AND ([CENTRO1]='H001' OR [CENTRO2]='H001' OR [CENTRO3]='H001' OR ...etc)

    ------------------------------
    John Carter
    Professional Services
    Blue Prism
    ------------------------------



  • 3.  RE: Filter set value in different columns

    Posted 06-09-2022 15:48

    Hi John! Thanks!

    but there's only one problem
    the centers are very today the worksheet has 177 columns
    And tomorrow it may have 90 or even 200, the number of columns will always change and I don't know how many columns it will have tomorrow, can you guide me?

    it would have to be something that filters according to the informed range, something like that, some code..

    Obs> Sorry for not posting this question in the thread



    ------------------------------
    José Francisco Bezerra Nunes Júnior
    ------------------------------



  • 4.  RE: Filter set value in different columns
    Best Answer

    Posted 06-09-2022 21:20
    @Jose Francisco

    ​Expanding on the reply from @John Carter​​, you could always use a few stages to build your filter based on the varying columns in your collection. And it all takes a couple of seconds to run.

    1. Use the "Get Collection Fields" action in the "Utility - Collection Manipulation" VBO. This will produce a collection (Fields Collection) of the existing field names in the collection.
    2. Use the "Filter Collection" action in the "Utility - Collection Manipulation" VBO to filter out the fields you want to filter on later into another collection (CENTR Fields). The "Filter" parameter would have the expression:
      "[Field Name] LIKE 'CENTR*'"
    3. Use the "Delete Column" action in the "Utility - Collection Manipulation" VBO to delete the "Data Type" field from the "CENTR Fields" collection.
    4. Use the "Rename Field" action in the "Utility - Collection Manipulation" VBO to rename the "Field Name" field to "Item Value" because that is what the next action expects for a collection.
    5. Now is the tricky part, using the "Join Text" action in the "Utility - Strings" VBO, we can build out a filter fragment (Joined Text) using all the desired fields in the "CENTR Fields" collection. The "Join Character" parameter would have the expression:
      "]='H001' OR ["
    6. To finish it off we use the "Filter Collection" action in the "Utility - Collection Manipulation" VBO to filter out all the rows with "Valor A" and "H001" in any of the 90-200 fields in your collection. The "Filter" parameter would have the expression:
      "[Material] ='Valor A' AND ([" & Left([Joined Text], Len([Joined Text])-5) & ")"
     


    ------------------------------
    Micheal Charron
    Senior Manager
    RBC
    America/Toronto
    ------------------------------



  • 5.  RE: Filter set value in different columns

    Posted 06-10-2022 09:21
    Hi Jose - if you can't predict the columns, then I would try something like Michael's suggestion. Maybe an easier to achieve variant would be to loop through the fields collection and build up a filter statement using a Calc, and then at the end of the loop apply the filter to the data. But Michael's idea looks good too.

    ------------------------------
    John Carter
    Professional Services
    Blue Prism
    ------------------------------



  • 6.  RE: Filter set value in different columns

    Posted 06-21-2022 13:57

    @Micheal Charron

    Thank you very much for your explanation and for being very detailed, follow your thank you for your compliment, thank you very much ​



    ------------------------------
    José Francisco Bezerra Nunes Júnior
    ------------------------------



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.