Multidimensional array from JSON object

Question

From JSON object below

{cols:[{"id":"t","label":"Title","type":"string"},{"id":"l","label":"Avg ","type":"string"},{"id":"lb","label":"High","type":"string"},{"id":"lo","label":"Low","type":"string"}],rows:[{"c":[{"v":"Change navigation"},{"v":5.6666666666667},{"v":"10"},{"v":"1"}]},{"c":[{"v":"Executive leadership"},{"v":6.0666666666667},{"v":"7"},{"v":"3"}]},{"c":[{"v":"Business ownership"},{"v":5.8095238095238},{"v":"10"},{"v":"2"}]},{"c":[{"v":"Change enablement"},{"v":6.4285714285714},{"v":"9"},{"v":"5"}]}]}

how can i get something like

[['Change navigation',6.5333333333333],['Executive leadership',6.0666666666667],['Business ownership',5.8095238095238],['Change enablement',6.4285714285714]]

somebody posted the code for one dimensional array from this.cant figure out multidimensional in javascript

var arr = [],
i = 0;
for (; i < json.rows.length; i++) {
arr.push(json.rows[i].c[0].v + '=' + json.rows[i].c[1].v);

}

which gives

['Change navigation=6.5333333333333','Executive leadership=6.0666666666667', 'Business ownership=5.8095238095238','Change enablement=6.4285714285714']

David Hedlund · Accepted Answer · 2012-08-22 11:48:53Z

3

Instead of pushing a concatenated string, push an entire array to your existing array:

var arr = [];
for(var i = 0, l = json.rows.length; i < l; i++) {
    arr.push([ json.rows[i].c[0].v, json.rows[i].c[1].v ]);
}

answered Aug 22, 2012 at 11:48

David Hedlund

130k33 gold badges205 silver badges223 bronze badges

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

Collectives™ on Stack Overflow

Multidimensional array from JSON object

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