Reduce an array of objects into a single object with the sum of fields as the result

Question

I have an array of the following form:I want to convert this array of objects into a single object that has the same fields along with&nbsp;Debit_Amount and Credit_Amount fields summed up.Any help is appreciated!

vgautam64 · Answer

Anyone?

vgautam64 · Answer

dmiller&nbsp;tstack&nbsp;bojanvelevski&nbsp;

supratim · Answer

vgautam64&nbsp; As I can't copy your json, have created my own, you can use it-&nbsp;Data&nbsp; ==&gt;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;"carList":&nbsp;[&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;"color":&nbsp;"purple",&nbsp;&nbsp;&nbsp;&nbsp;"type":&nbsp;"minivan",&nbsp;&nbsp;&nbsp;&nbsp;"debit_amount":&nbsp;50,&nbsp;&nbsp;&nbsp;&nbsp;"credit_amount":&nbsp;7&nbsp;&nbsp;},&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;"color":&nbsp;"red",&nbsp;&nbsp;&nbsp;&nbsp;"type":&nbsp;"station&nbsp;wagon",&nbsp;&nbsp;&nbsp;&nbsp;"debit_amount":&nbsp;100,&nbsp;&nbsp;&nbsp;&nbsp;"credit_amount":&nbsp;5&nbsp;&nbsp;},&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;"color":&nbsp;"black",&nbsp;&nbsp;&nbsp;&nbsp;"type":&nbsp;"toyota",&nbsp;&nbsp;&nbsp;&nbsp;"debit_amount":&nbsp;200,&nbsp;&nbsp;&nbsp;&nbsp;"credit_amount":&nbsp;5&nbsp;&nbsp;},&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;"color":&nbsp;"blue",&nbsp;&nbsp;&nbsp;&nbsp;"type":&nbsp;"Maruti",&nbsp;&nbsp;&nbsp;&nbsp;"debit_amount":&nbsp;300,&nbsp;&nbsp;&nbsp;&nbsp;"credit_amount":&nbsp;5&nbsp;&nbsp;}]}&nbsp;1. mapper&nbsp; :&nbsp;$carList.map((val,index)=&gt;{"sum_debit_amount": jsonPath($, "carList[*].debit_amount").reduce((cur,acc)=&gt;cur+acc),"sum_credit_amount" : jsonPath($, "carList[*].credit_amount").reduce((cur,acc)=&gt;cur+acc)}.extend(val)).shift()

bojanvelevski · Answer

Hi&nbsp;vgautam64&nbsp;,Try the following expression in a mapper:$group.reduce((acc,curr,ind)=&gt; acc.extend(curr.mapKeys((val,key)=&gt;key+ind)),{})Let me know what you think.Regards,Bojan

vgautam64 · Answer

Hi&nbsp;Supratim,Thanks for the providing a solution. I tried to validate the expression with the data I have and it seems to work when I validate the pipe. Strangely though, I observe that when I execute (not validate) the pipeline, the mapper that holds the expression only seem to process 50 records and gets stuck processing the 51st doc. But when I validate the pipe I am able to see the preview of 148 documents.Any idea why this would happen?

Forum Discussion

Reduce an array of objects into a single object with the sum of fields as the result

7 Replies

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found