Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Collections

MeghanStark
Level 3

‎08-07-20 03:21 PM

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
------------------------------
0 Likes
2 REPLIES 2

AmiBarrett
Level 12

‎08-07-20 04:00 PM

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

MeghanStark
Level 3
In response to AmiBarrett

‎08-07-20 04:52 PM

Thank you, checking it out now!

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