Forum Discussion

nirupama's avatar
nirupama
New Contributor II
3 years ago

Is it possible to perform group by and sum operation in Mapper/Conditional snap?

Is it possible to perform sum of the values by grouping them on few fields in mapper/conditional snap in snaplogic. Because with aggregate snap I’m losing all input fields and keeping copy snap is ...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
3 years ago

Same thing applies to your use case, just the grouping is a little bit different and you’ll have to use Group by Fields

nirupama's avatar
nirupama
New Contributor II
3 years ago

@bojanvelevski I was trying with this approach, but getting below error.

expression using : $.reduce((acc,curr)=> acc + curr.INSTALLCUQTY,0)
Also, getting ‘null’ as output for sum.

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    3 years ago

    Does it mean that your input is plain array literal and not an object array?

    The error you’re receiving is telling you that the instance of “curr” - current is a BigDecimal. Can you provide a sample payload here?