topic Collections in Product Forum

Collections

MeghanStark — Wed, 08 Jul 2020 14:21:00 GMT

Is there a way to copy fields from one collection to another? I am getting an Excel file with many fields into a collection, and I am going to append some of that data to another collection, but I'd also like to append the field names, if possible, so I don't have to define all of them manually.

Thanks!

------------------------------
Meghan Stark
Senior Analyst
Legal&General
America/New_York
------------------------------

RE: Collections

AmiBarrett — Wed, 08 Jul 2020 15:00:00 GMT

There's an extended version of the collection manipulation VBO I put up a while back (link below). Change the extension on it to .bprelease and see if it has what you're looking for. If there's at least one overlapping field on each row, I suspect the "Left Outer Join" action within it may help. Or, in the case where no fields match, you might try the "Append All" action.

https://community.blueprism.com/viewdocument/re-collection-vbo-useful-vbo

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Plano, TX
------------------------------

RE: Collections

MeghanStark — Wed, 08 Jul 2020 15:52:00 GMT

Thank you, checking it out now!

------------------------------
Meghan Stark
Senior Analyst
Legal&General
America/New_York
------------------------------