Find and count duplicates - Blue Prism

BPnovice

New Member
Hi,

I need some help with how I can find an count duplicates in a collection, I have a collection with two Fields and I need to be able to find and in a perfect world also count the number of times the same text appears in Field2. I can't really wrap my head around how I can do this.

The text in field2 will change for every run I do so I never know exactly what will be in that field or how many rows the collection will contain.

Does anyone have a good suggestion?
 

Attachments

  • Example.png
    9.7 KB · Views: 68

GatesV

Member
Hi emjemed,

That's done very easily by a filter you can apply to your collection using Utility - Collection Manipulation --> Filter Collection that you output to another collection. Then you can use Collections --> Count Rows to get the number of times that number is found in Field2.

All you need to do in include that into a loop that loops your main collection. See the attached pictures.
 

Attachments

  • 2019-11-12_15-22-41.jpg
    36.4 KB · Views: 104
  • 2019-11-12_15-17-04.jpg
    106.2 KB · Views: 89
Top