Join Two Collections

smithmrk

Member
Has anyone ever used this (see screen shot)...I want to join two collections together, but I'm not sure how to fill out the inputs.
I have a collection with Record ID's and a second collection with Record ID's and I want to join them together. Collection 1 is single rows, but Collection 2 is many rows.
Meaning...one to many type join.

Thanks,
Mark
 

Attachments

  • BluePrism-JoinCollection.jpg
    123.9 KB · Views: 209

arun_pmss

New Member
You can simply add rows to your collection 2 and use a multicalc stage to add data or simply use Append Rows to collection VBO to achieve the same.
 
Last edited:

smithmrk

Member
I was hoping someone could just tell me how to use that Join Collections Object...I know there are other ways around it, but I was hoping to understand more about this object and what needs to be passed into it.
 

VJR

Well-Known Member
Hi smithmrk,

I haven't got the new Collections Extended VBO with me to take a look at it.
But parameters 1, 2 and 3 appear to be straight forward if anyone knows something like SQL joins. You can do a web search if unaware of that.
To know what 'Join Type' is can you take a look at the Code stage of this action and see if it is understandable enough to know where/how it is used.
 
Has anyone ever used this (see screen shot)...I want to join two collections together, but I'm not sure how to fill out the inputs.
I have a collection with Record ID's and a second collection with Record ID's and I want to join them together. Collection 1 is single rows, but Collection 2 is many rows.
Meaning...one to many type join.
Could you please share the link of the collection manipulation extended VBO or screenshot of the code stage. This is very helpful
 

develop-rpa

New Member
Hi @smithmrk,

Unfortunately the Utility - Collection Manipulation - Extended.xml VBO is not available on the Blue Prism portal anymore? Is there any chance you could upload it here. It would be extremely helpfull. Thanks in advance!
 
Top