How to merge all objects in an array

[khanh_tran]

I got an array named “group” includes object items as the below picture

How can I merge all object items to one object? My expected result as the below picture. But, imagine that the number of item is unknown. It can be 3,4,5 , … (n).

Thank you!

[j_angelevski]

Hi @khanh_tran ,

You can use JSON Splitter after this output and split on $group, this will give you only the objects inside the group array then you can use a Group by N snap to group all input data into a single array ( don’t forget to set the setting Group Size to 0 ).

[khanh_tran]

khanh_tran:

an array named “grou

Thank you! But your answer is not my expectation. I need object[0] merge to object[1] and to object[n].

[j_angelevski]

If you merge all objects into one, the values will be overwritten for the key with the same name in each object. Is this what you want ?

[khanh_tran]

yes, sure. that’s all I want. Because every object will be not duplicated except the key-participant_survey_progress_sk. The field is also group by key, so it’s also not problem.