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