Create JSON based another JSON as key and value?

Question

I have json like

SampJson= [
    {
        data: "50",
        cIndex: "column0",rowno:"1"
    },
    {
        data: "5",
        cIndex: "column1",rowno:"1"
    },
    {
        data: "80",
        cIndex: "column0",rowno:"2"
    },
    {
        data: "65",
        cIndex: "column1",rowno:"2"
    }

];

I need to create a JSON like

[
    {
        rowno:1,
        column0:50,
        column1:5
    },
    {
        rowno:2,
        column0:80,
        column1:65
    }
];

Thanks in advance...

There is no JSON there. Just JavaScript objects / arrays / strings / numbers. — Quentin
– Quentin, Commented Aug 4, 2015 at 8:38

iplus26 · Accepted Answer · 2015-08-04 08:36:17Z

1

You should just do this:

sampJson = [
    {
        data: "50",
        cIndex: "column0",
        rowno: "1"
    },
    {
        data: "5",
        cIndex: "column1",
        rowno: "1"
    },
    {
        data: "80",
        cIndex: "column0",
        rowno: "2"
    },
    {
        data: "65",
        cIndex: "column1",
        rowno: "2"
    }
];

var results = [];

sampJson.forEach(function(el) {
    if (results[+el.rowno - 1] == null) {
        results[+el.rowno - 1] = new Object();
    }
    results[+el.rowno - 1].rowno = +el.rowno;
    results[+el.rowno - 1][el.cIndex] = +el.data;
});

console.log(results);

answered Aug 4, 2015 at 8:36

iplus26

2,69618 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create JSON based another JSON as key and value?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related