Javascript Populate key value with value is an array

Question

I want to iterate over a JSON in javasacript and create something like this as output

   {
    "seriesData": [
        {
            "name": "John",
            "data": [
                5,
                3,
                4
            ]
        },
        {
            "name": "Jane",
            "data": [
                2,
                2,
                3
            ]
        },
        {
            "name": "Joe",
            "data": [
                3,
                4,
                4
            ]
        }
    ]
}

So, I essentially need to add values in data array for each key inside my for loop.

Input looks like: {"Records":[{"name":"Jan'10","users":[{"name":"John","y":5},{"name":"Jane","y":2},{"name":"Joe","y":3}]},{"name":"Jan'10","users":[{"name":"John","y":3},{"name":"Jane","y":2},{"name":"Joe","y":4}]},{"name":"Jan'10","users":[{"name":"John","y":4},{"name":"Jane","y":3},{"name":"Joe","y":4}]}]};

Can someone please suggest how can this be achieved.

What exactly are you having problems with? Don't you know how to add values to an array? — Felix Kling
– Felix Kling, Commented May 4, 2014 at 16:39
How to associate an array to a key in JSON ? And I need to keep track of all the arrays as I need to decide iteratively based on key which array to add new value to — user1744413
– user1744413, Commented May 4, 2014 at 16:40
I think you have to provide more information, especially how your original data looks like and how exactly you are trying to convert it. — Felix Kling
– Felix Kling, Commented May 4, 2014 at 16:42
I am not sure if that helps, I changed the input to JSON as well. — user1744413
– user1744413, Commented May 4, 2014 at 16:59

Bellian · Accepted Answer · 2014-05-04 18:45:05Z

1

you could try something like this:

var dataList = {};
function addData(name){
    if( dataList[name] == undefined)
        dataList[name] = [];
    for (var i = 1; i < arguments.length; i++) {
        dataList[name].push(arguments[i]);
    }

}
function packData(){
    var pack = []
    for(var e in dataList){
        pack.push({
            name: e, 
            data:dataList[e].sort(function(a,b){return a-b})
        });
    }
    return pack;
}

addData("Joe", 1);
addData("Jan", 2, 10);
addData("Joe", 3, 5, 10, 18, 500);
addData("Jan", 4);
addData("Joe", 5);
addData("Jan", 6);
console.log( packData() );

use addData(name, data); to append data to a name and afterwards pack this data with packData()

EDIT: Sry switched to PHP for a while... fixed the script XD

edited May 4, 2014 at 18:45

answered May 4, 2014 at 16:43

Bellian

2,16016 silver badges23 bronze badges

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

6 Comments

user1744413 Over a year ago

dataList[name] .. what's that ? You are suggesting to use String as index ?

Bellian Over a year ago

an JS Object var a = {foo:"bar"} can be accessed via a.foo or a['foo'] which is usefull in manny cases.

user1744413 Over a year ago

Can you kindly suggest .. how can I sort this on keys ?

user1744413 Over a year ago

And if I want to push two values ..then

Bellian Over a year ago

you can sort the data as follows: dataList[e].sort(function compare(a, b) {return a-b})

|

Collectives™ on Stack Overflow

Javascript Populate key value with value is an array

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related