nirupama
New Contributor II
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Sum in a loop
@pmancevski How to apply the same logic on group by values. Sample data is attached below. Sum should be incremented by 10 for each row. [ { “groupBy”: { “number”: “1115122” }, “group”: [ { “name”: “TD”, “number”: “1115122”, “sum”: “390” }, { “name”: “TD”, “number”: “1115122”, “sum”: “390” } ] }, { “groupBy”: { “number”: “1115982” }, “group”: [ { “name”: “TD”, “number”: “1115982”, “sum”: “390” } ] }, { “groupBy”: { “number”: “1115962” }, “group”: [ { “name”: “TD”, “number”: “1115962”, “sum”: “390” } ] } ] required output: 1st group : sum=400, 410 2nd group : sum=400 3rd group : sum=4002.8KViews0likes0CommentsHow to get the cartesian product kind of output?
I have an Join(merge) output as below. [ { “BCUNAME”: “1q”, “REQUESTNUM”: “639431”, “no”: “4”, }, { “BCUNAME”: “e4” }, { “BCUNAME”: “rf” }, { “BCUNAME”: “14r” }, { “BCUNAME”: “26t” }, { “BCUNAME”: “3PH” } ] But I want to keep “REQUESTNUM”: “639431”, “no”: “4” in every row like below. [ { “BCUNAME”: “1q”, “REQUESTNUM”: “639431”, “no”: “4”, }, { “BCUNAME”: “e4”, “REQUESTNUM”: “639431”, “no”: “4”, }, { “BCUNAME”: “rf” “REQUESTNUM”: “639431”, “no”: “4”, }, { “BCUNAME”: “14r” “REQUESTNUM”: “639431”, “no”: “4”, }, { “BCUNAME”: “26t” “REQUESTNUM”: “639431”, “no”: “4”, }, { “BCUNAME”: “3PH” “REQUESTNUM”: “639431”, “no”: “4”, } ] Please suggestSolved2.8KViews0likes2CommentsRe: Is it possible to perform group by and sum operation in Mapper/Conditional snap?
Hi @bojanvelevski , Thanks you. I tried with group by N(It does batching randomly), but I want to group them based on 3 fields say $A,$B,$C and then I want to do SUM on other field $D.Is there any such functionalities available in snaplogic using mapper?4.3KViews0likes3CommentsIs 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 taking more time to execute.5.6KViews0likes5Comments