topic Combining Excel input collection with a header collection. in Product Forum

Combining Excel input collection with a header collection.

BenjaminDackerm — Mon, 17 Oct 2022 14:01:23 GMT

Hello i try to combine 2 collections with the Aktion Rename Collection fields. I try to save it in the input collection but it just deletes the data in the collection, but there is no error so i dont know whats going wrong. Also when i use a third collection it doesnt put any data in there as well.

Re: Combining Excel input collection with a header collection.

expertcr — Tue, 18 Oct 2022 21:52:42 GMT

We will need more information, like if you are using a VBO.
But I recommend you review the following KB Article (Troubleshooting Collections), which has many resources to help you when working with a collection.

Re: Combining Excel input collection with a header collection.

devneetmohanty07 — Tue, 18 Oct 2022 23:09:15 GMT

Hi @Benjamin Dackermann,

The way action, 'Rename Collection Fields' work is as follows:

As per the documentation, we need two collections where one is the source collection with headers which needs to be changed while other is a one-row mapping collection where headers would refer to the column names in the source collection while the data against each of the column of this collection would have the new column name which needs to be changed to.

Here is an example workflow for you to understand:

Input Collection:

Mapping Collection:

Action Properties:

Workflow & Results:

As you can see based on the 'Mapping Column' values, the headers of the 'Input Collection' got changed.

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------