cancel
Showing results for 
Search instead for 
Did you mean: 

Match and merge 2 excel spreadsheets to reduce the number of fields

DeborahParfitt
Level 3
Hello Team

I have 2 different spreadsheets, a) with approx 100 records and b) approx 35k records.  I need to match the reference number in a) with b) to reduce the number of records before reading into a collection.

Any suggestions on best way to do this.

Many thanks

Debbie


------------------------------
Deborah Parfitt
RPA Developer
BNPParibas PF UK
Europe/London
------------------------------
3 REPLIES 3

mkumar407
Level 7
Hi,

1. Use loop for collection a) and Filter collection for each reference number to match reference in b)
2. Save outputs in new collection - Either by Append rows to collection or by using Add Rows and Calc stage.


------------------------------
Manish Kumar
------------------------------

Thanks you Manish

Do you know if Blue Prism can easily handle reading in 35k records (57 columns) into a collection?

------------------------------
Deborah Parfitt
RPA Developer
BNPParibas PF UK
Europe/London
------------------------------

Hi Deborah,

Believe 35k records (57 columns) will be little hard on BP . Definitely it can load into collection however challenge will be to visualize data loaded into collection.
May be you want to play with Excel Macro so that data can be trimmed down.

------------------------------
Manish Kumar
------------------------------