Forum Discussion
thomson_mathews
6 years agoNew Contributor
Nevermind,the Excel file needs to be in byte array format
@pmancevski Thank you for the quick response. It helped.
@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=400
Related Content
- 10 months ago
- 5 years ago
- 7 months ago
- 4 years ago
- 2 years ago