Blue Prism Product

 View Only
last person joined: 17 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  Remove Duplicate In Collection

    Posted 03-17-2023 17:54

    Hi there,

    How to remove duplicate values from a collection. Let's say we have two column ( ID & NAME), if one id is having duplicate value then Bot should remove the complete row.

    Previously there are some discussion over community for this, but I didn't find any right solution.

    Kindly advise.



    ------------------------------
    Madhu Garg
    ------------------------------


  • 2.  RE: Remove Duplicate In Collection

    Posted 03-17-2023 18:55

    Hi Madhu Garg,

    It seems you are looking to eliminate the entire row basis on one Column Value for example see below collection - you would want to remove the entire row basis on the ID if you find that ID duplicate and doesn't matter what data comes after that ID duplication. 

    These can be easily done via Code Stage as below - First we need to Sort the Data (Collection Manipulation Object Action) you can find the VBO here if you don't have it : https://digitalexchange.blueprism.com/dx/entry/3439/solution/utility---collection-manipulation

    Then call the custom code to remove the entire row basis on the column you want to check it for. For creating a custom code - You can add an action in one of your extended objects for collection manipulations, make sure you have correct external references for Dll and their Namespaces listed in Initialise stage, please follow below approach:

    Code for Custom Action : Add an action in existing collection manipulation extended objects or create a new object if not already. Add a Code Stage.

    Set Inputs as : Collection Name and Column Name and Set Output.

    Write the Code in Code Stage:

    System.GC.Collect()
    'filteredCollection=RawData.clone()
    'filteredCollection=RawData.DefaultView.ToTable(true, columnToCheck)
    dim count as integer=rawData.rows.count-1
    dim i as integer =0
    dim rowIndex as integer
    for  rowIndex = rawData.rows.count-2 to 0 step rowIndex-1
        if rawData.rows(rowIndex).item(columnToCheck1)=rawData.rows(rowIndex+1).item(columnToCheck1)

            rawData.rows(rowIndex+1).delete
        end if
    next
    filteredCollection=rawData.copy()

    Publish and move back to process and Sort your collection which needs duplication removal and call the above action.

    Results:

    Cases where only single column values are to be checked for duplication row elimination - you can follow above approach for for multiple column check there are additional threads where I have said about duplication elimination depending on number of columns, if you have more than two or three columns validation for duplication elimination, you can refer that as well and observe how code changes - the code just adds few more conditions to check  pretty much straight forward- refer https://community.blueprism.com/discussion/remove-duplicate-rows-based-on-3-column-names?ReturnUrl=%2fcontent%2fallrecentposts



    ------------------------------
    Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

    Regards,

    Mukesh Kumar - Senior Automation Developer

    NHS England, United Kingdom, GB
    ------------------------------



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.