Group by JSON array using jQuery

Question

I have a set of JSON array and I want the result to be grouped by the "Id" column. I will not use underscore.js for this, as this can't be used in our project. The only option is to do it with jQuery. My source array and expected results are below.

var origObj = [{ "Id": "1", "name": "xxx", "age": "22" },
               { "Id": "1", "name": "yyy", "age": "15" },
               { "Id": "5", "name": "zzz", "age": "59" }]

var output = [{"1": [{ "Id": "1", "name": "xxx", "age": "22" },
                     { "Id": "1", "name": "yyy", "age": "15" }],
               "5": [{ "Id": "5", "name": "zzz", "age": "59" }]}]

I have tried with for loops, but that didn't work. That's why I am seeking help. — Deepak Ranjan Jena
– Deepak Ranjan Jena, Commented Jun 17, 2015 at 14:03
I don't see any JSON here at all. These are javascript array/object literals. — Mike Brant
– Mike Brant, Commented Jun 17, 2015 at 14:13

Lemon Kazi · Accepted Answer · 2018-09-06 13:48:10Z

12

You can use Array.prototype.reduce to get this done. Check this post for more details https://stackoverflow.com/a/22962158/909535 Extending on that this is what you would need

var data= [{ "Id": "1", "name": "xxx", "age": "22" },
        { "Id": "1", "name": "yyy", "age": "15" },
        { "Id": "5", "name": "zzz", "age": "59" }];
        console.log(data.reduce(function(result, current) {
            result[current.Id] = result[current.Id] || [];
            result[current.Id].push(current);
            return result;
        }, {}));

edited Sep 6, 2018 at 13:48

Lemon Kazi

3,3192 gold badges41 silver badges72 bronze badges

answered Jun 17, 2015 at 14:03

meteor

2,5784 gold badges40 silver badges59 bronze badges

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

4 Comments

Deepak Ranjan Jena Over a year ago

Hey!! Cool man. That worked. I just assigned that to a variable instead of printing on console.

Steve Johnson Over a year ago

This seems to work great!. Is it compatible across all web browsers?

Steve Johnson Over a year ago

seems like it is.. in the latest browsers.. developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/…

Krunalsinh Over a year ago

Its Cool, But how can I apply with multiple key group by?

Kamil Kiełczewski · Accepted Answer · 2019-07-08 07:07:16Z

0

Try

var origObj = [{ "Id": "1", "name": "xxx", "age": "22" },
               { "Id": "1", "name": "yyy", "age": "15" },
               { "Id": "5", "name": "zzz", "age": "59" }], output;
               
output = [origObj.reduce((a,c) => (a[c.Id]=(a[c.Id]||[]).concat(c),a) ,{})];

console.log(output);

answered Jul 8, 2019 at 7:07

Kamil Kiełczewski

93.7k34 gold badges401 silver badges375 bronze badges

Collectives™ on Stack Overflow

Group by JSON array using jQuery

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related