Comparing two collections in Blue Prism

R

rpaccount

Member
Hi,

I would like to compare two collections ( A&B) and remove the duplicate in A. I’ve been experimenting with two loops but it’s so confusing when i try to keep track of the row numbers.

I’ve tried some of the solutions in this forum but it didn’t really work for me.

Does anyone have a better idea? Or how would you guys do it.

Thanks!
 
R

rpaccount

Member
One of my attempt.
But it only removes the first value in the collection. Not the duplicates.

I tried using row numbers and it confuses me more.

Anyone experienced in this?

Thanks!
 

Attachments

  • Capture.PNG
    29.9 KB · Views: 437
Sukesh Kumaru

Sukesh Kumaru

Active Member
Hello,
I did it but, it won't delete the duplicates from that collection instead it copies the unique rows to another collection(Final).
PFA and go through for your clearer understanding.
 

Attachments

  • process.JPG
    78.7 KB · Views: 700
  • cl1.JPG
    22.8 KB · Views: 549
  • cl2.JPG
    29 KB · Views: 497
  • final.JPG
    24.6 KB · Views: 510
R

rpaccount

Member
Hi,

Now my concern is that, when i loop coll1, coll2 doesn't move at all. It keeps on checking the same folder of coll2.

Any ideas?
 

Attachments

  • Capture.PNG
    21 KB · Views: 327
P

peeletidevendra

New Member
Sukesh Kumaru said:
Hello,
I did it but, it won't delete the duplicates from that collection instead it copies the unique rows to another collection(Final).
PFA and go through for your clearer understanding.
Click to expand...

Hi sukesh,

can please send me images with logic in calc1,2 and collection contain values.
for better understanding.
 
A

aleeassad

New Member
Sukesh Kumaru said:
Hello,
I did it but, it won't delete the duplicates from that collection instead it copies the unique rows to another collection(Final).
PFA and go through for your clearer understanding.
Click to expand...

Hi Sukesh-can please send me images with logic in calc1,2 and collection contain values for better understanding?
 
B

Burks

New Member
Going to jump on the bandwagon here. I need to loop through a collection of around 5000 rows and check against a second collection of about 8 items to see if there's any matching items in the larger collection - if so then they need removing. Can anybody suggest a good way of doing this please?

I've tried the following but it takes about an hour to process and we need to speed it up: https://community.blueprism.com/com...-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer
 
You must log in or register to reply here.
Top