topic RE: Combining Collections in Product Forum

Combining Collections

JonathanHolstin — Tue, 10 Sep 2019 16:13:00 GMT

I have two collections that I need combined and added to a queue. What is the best approach to do this?

1) Combine the collections into one new collection and then add to queue? If so does someone have an example or guidance on this?
2) Is there a way to add to queue without first combining into a new collection?

Thanks!

------------------------------
Jonathan Holstine
Systems Accountant
Interior Business Center
America/Denver
------------------------------

RE: Combining Collections

sutirtha.gupta — Wed, 11 Sep 2019 21:47:00 GMT

Hi,

It will be good to make a single collection by joining the two collection into a one and then put it inside the queue.

You can do this using following ways,

1. BP Loop.. ( It will take too much time if the collections are big)

2. Code stage .. ( using LinQ, time will be less and readable)

3. If both the values are in the same excel then u can use sql queries to join them. ( time will be same but with very high volume of data it may give you, 'Out of memory exception)

If you need any more details let me know.

Regards

Sutirtha Gupta

TCS

------Original Message------

I have two collections that I need combined and added to a queue. What is the best approach to do this?

1) Combine the collections into one new collection and then add to queue? If so does someone have an example or guidance on this?
2) Is there a way to add to queue without first combining into a new collection?

Thanks!

------------------------------
Jonathan Holstine
Systems Accountant
Interior Business Center
America/Denver
------------------------------

RE: Combining Collections

JohnCohen — Tue, 17 Sep 2019 08:24:00 GMT

there is another thread with the same post https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=85&MessageKey=9a8fe504-66d9-4f45-8561-49cbf1e32130&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer&ReturnUrl=%2fcommunities%2fallrecentposts

------------------------------
Cohen
Romania
------------------------------

RE: Combining Collections

JonathanHolstin — Tue, 17 Sep 2019 13:35:00 GMT

Hi John,
I believe my question posted to two different forums.

Thanks,

Jon

------------------------------
Jonathan Holstine
Systems Accountant
Interior Business Center
America/Denver
------------------------------