Issue while merging the collection

[SpoorthyRajendr]

​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

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

[John__Carter]

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

[PrasanthChiruku]

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

[PrasanthChiruku]

Refer to the below sample code.  

 

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

[SpoorthyRajendr]

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

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