topic RE: Match and merge 2 excel spreadsheets to reduce the number of fields in Product Forum

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

DeborahParfitt — Mon, 21 Jun 2021 16:15:00 GMT

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
------------------------------

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

mkumar407 — Tue, 22 Jun 2021 02:32:00 GMT

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
------------------------------

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

DeborahParfitt — Tue, 22 Jun 2021 09:30:00 GMT

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
------------------------------

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

mkumar407 — Tue, 22 Jun 2021 10:04:00 GMT

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
------------------------------