Blue Prism Product

 View Only
last person joined: 18 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  Filtering collection

    Posted 03-17-2021 14:45

    Hi team,
    i've a collection with around 30 columns, but for my process i need only 5 columns, i know the name of the column, so how can i filter only these 5 columns and delete the rest?
    I'm able to do that with a loop through "delete column name" collection but i think it's not the best approach, can you suggest some actions?

    The second question is: how can i filter this collection and have in ouput a new collection with, for example, column1 only with numeric value, and delete the string/blank values?

    Thanks in advance,
    VH 



    ------------------------------
    Vrat Himbo
    ------------------------------


  • 2.  RE: Filtering collection

    Posted 03-17-2021 16:28
    Hi Vrat Himbo,

    For the first point, instead of removing the remaining 25 columns, I would create a new collections by extracting the 5 columns that I need.

    For the second point in the action filter collection the inputs Filter unless the value of the field you are filtering has a pattern or starts or ends with a certain letter or word it could be filtered but if I can't give you an idea I would add it to a loop where I validate the value of the field with the Functions IsNumber, if it is numeric, the loop continues if not I remove the record with the Business Object: Collections - Action: Remove Rows.

    I hope to see you helped

    Best regards

    ------------------------------
    Jhogel Ponne
    Senior RPA
    Ernst & Young
    America/Panama
    ------------------------------

    Original Message


  • 3.  RE: Filtering collection

    Posted 03-18-2021 08:35
    "Here be dragons"​ - removing rows from collection in a loop might not work as expected.
    I think Blueprism might restart the loop if dt.Length changes, but not sure atm.

    ------------------------------
    Andrey Kudinov
    Project Manager
    MobileTelesystems PJSC
    Europe/Moscow
    ------------------------------

    Original Message


  • 4.  RE: Filtering collection

    Posted 03-18-2021 09:14
    Thanks for your response @Jhogel Ponne.

    1) How can i extract only my 5 columns?

    2)​ If the loop might not work as expected, can be a good approach to loading into the queue and validate the item in the "validate item" page?

    ------------------------------
    Vrat Himbo
    ------------------------------

    Original Message


  • 5.  RE: Filtering collection

    Posted 03-18-2021 09:28
    There is a Split collection action in Collection manipulation that you can use to get only 5 columns you need.
    You can use loop to delete rows, but you better do it in two passes: validate and mark rows for removal in a loop, then just filter them out.

    ------------------------------
    Andrey Kudinov
    Project Manager
    MobileTelesystems PJSC
    Europe/Moscow
    ------------------------------

    Original Message


  • 6.  RE: Filtering collection

    Posted 03-18-2021 09:18
    Thanks for your response @Andrey Kudinov,

    in your opinion, which can be the best approach to manage an excel input file --> ​collection before it come loaded into the queue?
    My collection has an header, footer and some empty columns to be deleted.

    Thanks in advance

    ------------------------------
    Vrat Himbo
    ------------------------------

    Original Message


  • 7.  RE: Filtering collection

    Posted 03-19-2021 09:57
    Hi Guys,
    thanks for your support. 
    I've tried the bpa process and it works fine. 
    My bad is that i'm not able to use the split collection instead because some empty column will be added in the future in this input file.
    So, can be a good approach the one below?
    1) Delete empty column by column name reported in a collection
    2) Remove the last *fixed number* row
    3) Remove empty rows
    4) Load to the queue
    5) Validate Item (Is numeric?)

    Thx

    ------------------------------
    Vrat Himbo
    ------------------------------

    Original Message


  • 8.  RE: Filtering collection

    Posted 03-18-2021 09:23
    The Utility - Collection Manipulation.Split Collection action might help you. You provide three collection inputs - the 30 column original, a 5 column template and a 25 column template. The templates cannot be empty but a blank row is enough.

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

    Original Message


  • 9.  RE: Filtering collection

    Posted 03-18-2021 09:31
    You can just pass same template twice, that should work too.

    ------------------------------
    Andrey Kudinov
    Project Manager
    MobileTelesystems PJSC
    Europe/Moscow
    ------------------------------

    Original Message


  • 10.  RE: Filtering collection

    Posted 03-18-2021 16:29
      |   view attached
    Hi, 

    Here is an example of the second point raised, eliminate the row inside a loop, validating a field of the collections is numeric. The collections does not restart.

    You have to change the extension of the .txt file to .bpprocess

    I owe you the first point for now, but what the other members are saying is a good option.

    You let us know how you have done with these other approaches.

    I hope to see you helped

    Best regards

    ------------------------------
    Jhogel Ponne
    Senior RPA
    Ernst & Young
    America/Panama
    ------------------------------

    Original Message


Related Content

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.