I am facing some issues. i have following json in my memory and i want to find the count prod_id. can you please help. Thanks in Advance
[
{
"Prod_Id": "002",
"cost": " 4803600.000"
},
{
"Prod_Id": "004",
"cost": " 3706404.000...
I am facing some issues. i have following json in my memory and i want to do the sum of cost for every unique prod_id. can you please help. Thanks in Advance
[
{
"Prod_Id": "002",
"cost": " 4803600.000"
},
{
"Prod_Id": "004",
...
Thank you so much Daniel for this present. The solution worked. But i am unable to understand it how it is extracting the count. I had also created a separate question also.
If i want the count of Prod_id like below then what will be the scripting?[{
"Prod_Id": "001",
"Count": "1"
},{
"Prod_Id": "002",
"Count": "8" },{
"Prod_Id": "003",
"Count": "2" },
....
]
