Set Collection Field Overwrites Previous Values Rows

rpame

New Member
Hi everyone. I hope everything is well in these crazy times.
So I have a problem when I am trying to Set Collection Field in my collection and that is that it overwrites previous values on other rows.
I have my collection with 3 rows, I write in values on the first row and goes to row number two to write in values, and boom, it removes the value
on the first row when writing to the second row. Why is this?

Here is how I have set up the Set Collection Field. The output of this action is a new collection because if I use the one I am reading from it reset my loop and always starts from index 0.
View attachment 1585208506004.png
 

maubrey

New Member
Each time you output into collection 2, you're copying all of collection 1 plus the update you're making. The update to row 0 isn't reflected in collection 1 - only in collection 2 - so when you update row 1, and output to collection 2, the values of collection 1 are copied as is - along with the most recent change to row 1 and any changes previously output to collection 2 on row 0 are lost.

Alternatively, use a single collection and a loop, test whether the condition is met/matched, and use a calc stage to update [Collection.Field Name] if it is.
 
Top