topic ADDING COLUMN DATA FROM OTHER COLLECTION in Product Forum

ADDING COLUMN DATA FROM OTHER COLLECTION

VYDYAABHIRAM — Thu, 07 Apr 2022 09:49:00 GMT

How to add column data from one collection to other collection by comparing the collections made from two excel tables.

------------------------------
VYDYA ABHIRAM
------------------------------

RE: ADDING COLUMN DATA FROM OTHER COLLECTION

PabloSarabia — Thu, 07 Apr 2022 10:06:00 GMT

Hi @VYDYA ABHIRAM

If you have all the info in the same Excel file, I will recommend you to access this information by using the OLEDB VBO, here you have the link from the Digital Exchange https://digitalexchange.blueprism.com/dx/entry/3439/solution/data---oledb

You can use this assets to make a query over the Excel file and join the two tables in a simple query to extract the info.

Hope this helps you!

See you in the community, bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------

RE: ADDING COLUMN DATA FROM OTHER COLLECTION

VYDYAABHIRAM — Thu, 07 Apr 2022 10:14:00 GMT

We have only trail version so with the action present in the excel vbo only. We have to send the column data from one excel to other excel. So if u have any solution in that case let us know.
Regards
ABHIRAM.

------------------------------
VYDYA ABHIRAM
------------------------------

RE: ADDING COLUMN DATA FROM OTHER COLLECTION

PabloSarabia — Thu, 07 Apr 2022 12:51:00 GMT

Hi @VYDYA ABHIRAM

If I understand well, you want to "mix" to collection and paste the result in an Excel File. And the two collection that you want to mix are extracted from two different Excel, that right?

For this, you can create a Business Object to combine the collections. With a code stage and some Linq statements you can achieve this.

Then, need to open the Excel File with the MS Excel's VBO and use the action "Write Collection" to put the new collection that you combine before in a new sheet.

If I wrong with the explication of this, please send us any example to understand better the problem.

Bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------