Merge values of array by duplicate keys

Question

Trying to merge duplicate keys of json array and build respective values in csv format.

A=[{a:1,b:2},{a:1,b:1},{a:1,b:6},{a:2,b:5},{a:2,b:3}]

Trying to convert in

A=[{a:'1',b:'2,1,6'},{a:2,b:'5,3'}]

code Which i tried

var existingIDs = [];
        A= $.grep(A, function (v) {
            if ($.inArray(v.a, existingIDs) !== -1) {
                return v.b+= ',';
            }
            else {
                existingIDs.push(v.a);
                return true;
            }
        });

the output is returns like

A=[{a:1,b:2},{a:1,b:'1,'},{a:1,b:'6,'},{a:2,b:5},{a:2,b:'3,'}]

Please care to comment.... down voters

joshua
– joshua

2013-10-01 13:56:26 +00:00
Commented Oct 1, 2013 at 13:56 — joshua
– joshua, Commented Oct 1, 2013 at 13:56

Michael Geary · Accepted Answer · 2013-10-03 07:29:55Z

2

Create a temporary object with 1, 2 etc from a as keys and keep adding on the b values, then iterate over that object creating the new array :

var A = [{a:1,b:2},{a:1,b:1},{a:1,b:6},{a:2,b:5},{a:2,b:3}];
var temp = {};

for (var i=0; i<A.length; i++) {
    temp[A[i].a] =
        temp[A[i].a] === undefined ?
            A[i].b :
            temp[A[i].a] + ',' + A[i].b;
}

A = [];

for (var key in temp) {
    A.push({a: key, b:temp[key]})
}

FIDDLE

edited Oct 3, 2013 at 7:29

Michael Geary

29k9 gold badges67 silver badges77 bronze badges

answered Oct 1, 2013 at 14:01

adeneo

319k29 gold badges410 silver badges392 bronze badges

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

Collectives™ on Stack Overflow

Merge values of array by duplicate keys

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related