1

I have this data below(i have many record like this: the year org_name etc are many as well)

[{
    "year": "2015",
    "org_name": "MOOE",
    "suborg_name": "Forms Expenses",
    "amt": "2",
    "org_id": "4",
    "suborg_id": "24"
}, {
    "year": "2016",
    "org_name": "MOOE",
    "suborg_name": "Forms Expenses",
    "amt": "1",
    "org_id": "4",
    "suborg_id": "24"
},{
    "year": "2015",
    "org_name": "MOOE1",
    "suborg_name": "Forms Expenses1",
    "amt": "2",
    "org_id": "41",
    "suborg_id": "241"
}, {
    "year": "2016",
    "org_name": "MOOE1",
    "suborg_name": "Forms Expenses1",
    "amt": "1",
    "org_id": "41",
    "suborg_id": "241"
}]

I want to get this format

[{
    "org_name": "MOOE",
    "suborg_name": "Forms Expenses",
    "suborg_id": "24",
    "org_id": "4",
    "Year": [{
        "year": "2015",
        "amt": "2"
    }, {
        "year": "2016",
        "amt": "1"
    }]
},{
    "org_name": "MOOE1",
    "suborg_name": "Forms Expenses1",
    "suborg_id": "241",
    "org_id": "41",
    "Year": [{
        "year": "2015",
        "amt": "2"
    }, {
        "year": "2016",
        "amt": "1"
    }]
}]

What i want is to group them when the org_name suborg_name suborg_id org_id are the same. There will be different year and value for those data.

I am working on this :

var b={result{}};
for (i=0;i<a.result.length;i++)
{
    b.result[a.result[i].category] = b.result[a.result[i].category] || {};//use existing, or create new object
    b.result[a.result[i].category][a.result[i].event] = a.result[i].result;//add property for event type, assign value
}

From : link

But i cant make it work.Any easier implementation is appreciated

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.