Error while apending two colelctions

[Kumar_BabuK]

​Hi Everyone,

while appending two collections am getting the above mentioned error.I have same set of column names and data in both collections.this error is not occurring at same collection set when I run , also this is happening while I try to append a row of values to the collection with 0 rows.Quit a few times it ran successfully but it throws error also at other times.not sure where it is wrong.can someone help me

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

Thanks
Kumar

------------------------------
Kumar Babu K
Senior Software Engineer
wipro technologies
Asia/Kolkata
------------------------------

[shashank.kumar280]

Hi Kumar Babu,

Before running the append collection action, check to make sure the fields in the two collections are defined and same. You can get this error if you have 0 rows but no field defined in one of the collections.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Asia/Singapore
+6581326707
------------------------------

[Kumar_BabuK]

Hi Shashank,

thank you for your reply, but in my case I am able to append rows with no fields defined in another action but in different action I couldn't be able to do it. I wonder why it is working irregularly.
is there any alternative to append rows from one collection to other without using this VBO action?

Thanks
Kumar​

------------------------------
Kumar Babu K
Senior Software Engineer
wipro technologies
Asia/Kolkata
------------------------------

[shashank.kumar280]

Hi Kumar Babu,

Alternatively you can try to use Add Row & Multi Calc action within a loop to append rows from main collection to another collection.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------