cancel
Showing results for 
Search instead for 
Did you mean: 

Sum of values in array of objects without reduce function

Tanmay_Sarkar
New Contributor III

Hello all,

I stumbled upon a situation where I have to find out a sum of a certain key in the objects residing in an array without reducing the objects? What I mean to say is, here is the input:

[
{
key1: value1,
key2: 10
},
{
key1: value2,
key2: 20
},
{
key1: value3,
key2: 30
}
]

The output that I am expecting should look like:

[
{
key1: value1,
key2: 10,
sum: 60
},
{
key1: value2,
key2: 20,
sum: 60
},
{
key1: value3,
key2: 30,
sum: 60
}
]

The total sum of key 2 values should be pushed into each object as a new key.

Can some one please suggest how to deal with this? Reducing won’t be the optimal solution as it would discard the objects and just add a new object with the total sum.

Thanks.

1 ACCEPTED SOLUTION

skatpally
Former Employee

You can use merge function too.

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439367/Object+Functions+and+Properties#Ob...

Community_Example_2021_05_11.slp (3.5 KB)

$group.map(x=>x.merge({“sum”:$group.map(item => item.key2).reduce((accum, currentValue) => accum + currentValue)}))

View solution in original post

7 REPLIES 7

bojanvelevski
Valued Contributor

Hi @Tanmay_Sarkar,

You can also use Apache Velocity within JSON Generator. Here is the script:


#set($sum = 0)
#foreach ($field in $group)
#set($sum=$sum+$field.key2)
#end

#foreach($field in $group)
#set($dummy = $field.put(“sum”,$sum))
#end

{“group”:$group}


Regards,
Bojan

@bojanvelevski Thanks a lot, I never realized Apache Velocity can be used within JSON generator in such a way, this would come in handy in future.

Tanmay_Sarkar
New Contributor III

@skatpally Thanks a lot, this worked effortlessly.