Adding values to dynamically added rows

mohnish34

New Member
How to add values to the rows which are added from collections->Add Row.
We can add rows dynamically, but how to insert row values dynamically?

Plz clarify. I am pretty new to blue prism. So your suggestions and feedback will be really helpful to me.
 

VJR

Well-Known Member
Hello mohnish34,

Once the Add Row is used you need to use the Calculation stage to insert values to that row.
A calculation stage can be used if you want to update only 1 column of a collection at a time (else you need to take 1 Calc stage each for every single column).
But if you want to update multiple columns in one go then you can use the Multi Calculation stage.

The attached screenshots are using the Multi Calc stage.

- Screenshot 1 is how the overall diagram looks like
- Screenshot 2 is the properties screen of the Multi Calc stage
- Screenshot 3 is the output of the collection after the process is run
- The important part is the Screenshot 4 where you need to give the name of the collection within double quotes else will show a data type error (Yellow highlighted).


Best wishes,
VJ
 

Attachments

  • 1. Collection Diagram.JPG
    1. Collection Diagram.JPG
    33.6 KB · Views: 1,795
  • 2. Multi Calculation stage.JPG
    2. Multi Calculation stage.JPG
    60.6 KB · Views: 1,798
  • 3. Output of collection.JPG
    3. Output of collection.JPG
    41 KB · Views: 1,691
  • 4. Collection Name.JPG
    4. Collection Name.JPG
    43.4 KB · Views: 1,601

salmantahir31

New Member
Hello mohnish34,

Once the Add Row is used you need to use the Calculation stage to insert values to that row.
A calculation stage can be used if you want to update only 1 column of a collection at a time (else you need to take 1 Calc stage each for every single column).
But if you want to update multiple columns in one go then you can use the Multi Calculation stage.

The attached screenshots are using the Multi Calc stage.

- Screenshot 1 is how the overall diagram looks like
- Screenshot 2 is the properties screen of the Multi Calc stage
- Screenshot 3 is the output of the collection after the process is run
- The important part is the Screenshot 4 where you need to give the name of the collection within double quotes else will show a data type error (Yellow highlighted).


Best wishes,
VJ




What if we want to add two or three more rows to this collection without overwriting the already placed row?
 

erpreeti09

New Member
Hello mohnish34,

Once the Add Row is used you need to use the Calculation stage to insert values to that row.
A calculation stage can be used if you want to update only 1 column of a collection at a time (else you need to take 1 Calc stage each for every single column).
But if you want to update multiple columns in one go then you can use the Multi Calculation stage.

The attached screenshots are using the Multi Calc stage.

- Screenshot 1 is how the overall diagram looks like
- Screenshot 2 is the properties screen of the Multi Calc stage
- Screenshot 3 is the output of the collection after the process is run
- The important part is the Screenshot 4 where you need to give the name of the collection within double quotes else will show a data type error (Yellow highlighted).


Best wishes,
VJ


Thanks, it worked for me.
 
Top