How to add values to collection in Object studio
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-05-22 01:27 PM
Hello,
I have multiple read stages in my Object studio and I would like to add the data returned from each read stage into a collection (consecutive rows).
Anyone throws some light on how that can be done?
------------------------------
Roshini Syed
------------------------------
I have multiple read stages in my Object studio and I would like to add the data returned from each read stage into a collection (consecutive rows).
Anyone throws some light on how that can be done?
------------------------------
Roshini Syed
------------------------------
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-05-22 02:21 PM
Hi @Roshini Syed
If you want to add one line in a collection for each value readed with your read stage, you should make something like this:

You can simplify the read part by adding elements to read in the same Read Stage. When you have all the data, use the Action "Add Row" from the internal VBO Collections to add new lines to your collection. Then use a Calculation Stage to insert the value.
You will get this as result:

Is this what are you looking for?
Is a little bit weird this way... If you bring us more info we can give you a better solution I think. (Like... adding a loop to write in the collection easily or similar)
See you in the Community, bye 🙂
------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------
If you want to add one line in a collection for each value readed with your read stage, you should make something like this:
You can simplify the read part by adding elements to read in the same Read Stage. When you have all the data, use the Action "Add Row" from the internal VBO Collections to add new lines to your collection. Then use a Calculation Stage to insert the value.
You will get this as result:
Is this what are you looking for?
Is a little bit weird this way... If you bring us more info we can give you a better solution I think. (Like... adding a loop to write in the collection easily or similar)
See you in the Community, bye 🙂
------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-05-22 02:43 PM
Thank a lot for your Prompt response Pablo Sarabia,.will try this out.
------------------------------
Roshini Syed
------------------------------
------------------------------
Roshini Syed
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-05-22 02:58 PM
Hi Sarabia,
Thia is exactly what I am looking for ,but if there is any way to write the data in collection with the loop?
------------------------------
Roshini Syed
------------------------------
Thia is exactly what I am looking for ,but if there is any way to write the data in collection with the loop?
------------------------------
Roshini Syed
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-05-22 03:10 PM
You can write directly into the collection if you want. First you make sure the collection has an empty row, then you use the 'Collection.Field' notation as Store In destination.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------
------------------------------
John Carter
Professional Services
Blue Prism
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
20-05-22 03:05 PM
Hi,
@John Carter yeah! Your version looks more clean. I totally miss that you can write directly with the Read Stage instead of storing it in a Data Item.
@Roshini Syed I think is hard to implement a loop here. As you see, exists different fields in the screen that you want to read. The only way I can think of is trying to search a method to implement a Dynamic Attribute in the Application modeller, for example, the field's path. Then, have all the paths in a collection, and looping through this collection changing the Dynamic Attribute and Reading and Writing the values.
But this way looks long and hard to maintenance if something change, I don't know 😞
Hope this helps you!!
See you in the Community, bye :)
------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------
@John Carter yeah! Your version looks more clean. I totally miss that you can write directly with the Read Stage instead of storing it in a Data Item.
@Roshini Syed I think is hard to implement a loop here. As you see, exists different fields in the screen that you want to read. The only way I can think of is trying to search a method to implement a Dynamic Attribute in the Application modeller, for example, the field's path. Then, have all the paths in a collection, and looping through this collection changing the Dynamic Attribute and Reading and Writing the values.
But this way looks long and hard to maintenance if something change, I don't know 😞
Hope this helps you!!
See you in the Community, bye :)
------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------
