topic RE: Issue while merging the collection in Product Forum

Issue while merging the collection

SpoorthyRajendr — Fri, 06 Sep 2019 10:42:00 GMT

Hello Everyone,

I am facing an issue while merging the data from two collection where I am getting an error message as "

System Exception : Field definitions do not match - the number of columns in each is different."

Scenario:

First collection contain my Master Excel Sheet
Second Collection contain the child excel sheet

I am trying to merge the collection using Utility Collection Manipulation as Business and Action as Append rows. When I am doing this step my process is getting failed stating " System Exception : Field definitions do not match - the number of columns in each is different." but my collections(both) contains the same fields and definition.

Can anyone help me here how to fix this issue.

Thanks in advance.

------------------------------
Spoorthy

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

RE: Issue while merging the collection

John__Carter — Fri, 06 Sep 2019 13:01:00 GMT

I'd look again at your two collections, there has to be some discrepancy. Also set up a dummy test just to prove to yourself that the function works.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Issue while merging the collection

PrasanthChiruku — Fri, 06 Sep 2019 16:43:00 GMT

Try to rename the Field names using Rename Collection filed action in Utility collection manipulation then use append rows to collection it might help

------------------------------
Prasanth Chirukuri
RPA Developer
Zettamine
Asia/Kolkata
------------------------------

RE: Issue while merging the collection

PrasanthChiruku — Sat, 07 Sep 2019 18:06:00 GMT

Refer to the below sample code.

------------------------------
Prasanth Chirukuri
RPA Developer
Zettamine
Asia/Kolkata
------------------------------

RE: Issue while merging the collection

SpoorthyRajendr — Fri, 04 Oct 2019 06:21:00 GMT

I used the Get Worksheet Range as collection as an action and issue is solved .. Thanks

------------------------------
Spoorthy Rajendra
Application Team Lead
Accenture
------------------------------