how to group by the array values dynamically in javascript

Question

hi all i am using javascript i have a set of array i need to group by the object

code

 var data = [{BuildingID: "5", FloorId: "65", one: 12, two: 15,three: 12},
            {BuildingID: "5", FloorId: "65", one: 12, two: 15,three: 12},
            {BuildingID: "6", FloorId: "65", one: 12, two: 15,three: 12},
            {BuildingID: "6", FloorId: "65", one: 12, two: 15,three: 12}]

i am trying to do group by the BuildingID add one,two,three NOTE:one two three is not static

Excepted Output

  var data = [{BuildingID: "5", FloorId: "65", one: 24, two: 30,three: 24},
              {BuildingID: "6", FloorId: "65", one: 24, two: 30,three: 24} ]

expected result json??

Jins Peter
– Jins Peter

2017-06-06 12:35:02 +00:00
Commented Jun 6, 2017 at 12:35 — Jins Peter
– Jins Peter, Commented Jun 6, 2017 at 12:35
what should happen with one, two, three?

Nina Scholz
– Nina Scholz

2017-06-06 12:35:24 +00:00
Commented Jun 6, 2017 at 12:35 — Nina Scholz
– Nina Scholz, Commented Jun 6, 2017 at 12:35
expected result json array @JinsPeter

jose
– jose

2017-06-06 12:36:18 +00:00
Commented Jun 6, 2017 at 12:36 — jose
– jose, Commented Jun 6, 2017 at 12:36
one two three sometime four five also come @Nina Scholz

jose
– jose

2017-06-06 12:36:51 +00:00
Commented Jun 6, 2017 at 12:36 — jose
– jose, Commented Jun 6, 2017 at 12:36
@jose can u show examle result.?

Jins Peter
– Jins Peter

2017-06-06 12:36:52 +00:00
Commented Jun 6, 2017 at 12:36 — Jins Peter
– Jins Peter, Commented Jun 6, 2017 at 12:36

Nina Scholz · Accepted Answer · 2017-06-06 12:51:29Z

3

You could use a dynamic approach by using a hash table and an array for the static keys of the object.

var data = [{ BuildingID: "5", FloorId: "65", one: 12, two: 15, three: 12 }, { BuildingID: "5", FloorId: "65", one: 12, two: 15, three: 12 }, { BuildingID: "6", FloorId: "65", one: 12, two: 15, three: 12 }, { BuildingID: "6", FloorId: "65", one: 12, two: 15, three: 12 }],
    staticKeys = ['BuildingID', 'FloorId'] ,
    grouped = data.reduce(function (hash) {
        return function (r, a) {
            var key = a[staticKeys[0]];
            if (!hash[key]) {
                hash[key] = {};
                staticKeys.forEach(function (k) {
                    hash[key][k] = a[k];
                });
                r.push(hash[key]);
            }
            Object.keys(a).forEach(function (k) {
                if (staticKeys.indexOf(k) === -1) {
                    hash[key][k] = (hash[key][k] || 0) + a[k];
                }
            });
            return r;
        };
    }(Object.create(null)), []);

console.log(grouped);

.as-console-wrapper { max-height: 100% !important; top: 0; }

edited Jun 6, 2017 at 12:51

answered Jun 6, 2017 at 12:42

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

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

3 Comments

Nina Scholz Over a year ago

it contains the keys for the static values. as hash key, it uses then value of the object with the key of index zero.

Nina Scholz Over a year ago

does it mean, you need to use both as grouping key?

jose Over a year ago

Now it's working add two more fields in group by means what should i fo @Nina var key = a[staticKeys[0,1]];?

fxlacroix · Accepted Answer · 2017-06-06 13:14:17Z

1

here is a snippet code that work for me,

it assums you know the key attribute of the object

var arr = [ { id: 1, name: 'bob' }, { id: 1, name: 'bill' }, { id: 1, name: 'bill' } ]

var noDuplicate = [];
var unique = {};

$.each(arr, function(key, item) {

    if (! unique[item.id + "-" + item.name]) {
        noDuplicate.push(item);
        unique[item.id + "-" + item.name] = true;
    }
});

console.log(noDuplicate);

hope it helps ;)

regards.

answered Jun 6, 2017 at 13:14

fxlacroix

5674 silver badges18 bronze badges

1 Comment

jose Over a year ago

try to make a fiddle @fxlacroix

Arno · Accepted Answer · 2017-06-09 09:22:19Z

1

You can try this snippet, the "ouput" variable contains the result;

var data = [{ BuildingID: "5", FloorId: "65", one: 12, two: 15, three: 12 }, { BuildingID: "5", FloorId: "65", one: 12, two: 15, three: 12 }, { BuildingID: "6", FloorId: "65", one: 12, two: 15, three: 12 }, { BuildingID: "6", FloorId: "65", one: 12, two: 15, three: 12 }]
var groupBy = function(input, key) {
   return input.reduce(function(list, x) {
     list[x[key]] = x;
     return list;
   }, {});
};
var grouped = groupBy(data, 'BuildingID'), output=[];
for ( var key in grouped ) { output[output.length] = grouped[key]; }
console.log(output);

answered Jun 9, 2017 at 9:22

Arno

1,35915 silver badges22 bronze badges

Collectives™ on Stack Overflow

how to group by the array values dynamically in javascript

code

Excepted Output

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

code

Excepted Output

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related