I have a array like this and I want a desired output based on username and number of services booked by user. I want data such as number of quantity of services related to username
`[
{
"customerNo": 1001,
"username": "user3",
"serviceName": "Tempo",
"quantity": 1,
},
{
,
"customerNo": 1002,
"username": "user4",
"serviceName": "Social",
"quantity": 1,
},
{
"customerNo": 1001,
"username": "user3",
"serviceName": "Mango",
"quantity": 1,
},
{
"customerNo": 1001,
"username": "user3",
"serviceName": "Mango",
"quantity": 1,
},
{
"customerNo": 1003,
"username": "user5",
"serviceName": "Social",
"quantity": 1,
},
{
"customerNo": 1002,
"username": "user4",
"serviceName": "Social",
"quantity": 1,
}
]`
Desired output:
`[
{
"customerNo": 1001,
"username": "user3",
"serviceName": "Tempo",
"quantity": 1,
},
{
"customerNo": 1001,
"username": "user3",
"serviceName": "Mango",
"quantity": 2,
},
{
"customerNo": 1002,
"username": "user4",
"serviceName": "Mango",
"quantity": 2,
},
{
"customerNo": 1003,
"username": "user5",
"serviceName": "Social",
"quantity": 1,
}
]`
Thanks in advance.
I did tried for forEach , reduce but could not get desired result may be I am doing something wrong.