Transform an Array of Objects

Question

I have an object with structure of:

[ 
  {"vid":"aaa", "san":12}, 
  {"vid":"aaa", "san":18}, 
  {"vid":"aaa", "san":2}, 
  {"vid":"bbb", "san":33}, 
  {"vid":"bbb", "san":44}, 
  {"vid":"aaa", "san":100}
]

This object is passed to function called SerializeData(inData) as inData variable:

function SerializeResults( inData ) {
    $.each( inData, function( i, val ) { ... })
}

I want to iterate all objects in inData and transform them, so the result will be like this:

[ 
  { "vid":"aaa","san":[12,18,2,100] }, 
  { "vid":"bbb","san":[33,44] } 
]

How do I do that?

what do you think you need to do? What have you tried? Try to write this in a dummy language, just to understand how you can solve this problem. Then try to convert that to JavaScript and ask more specific questions about your problems. — Wouter J
– Wouter J, Commented Mar 24, 2013 at 16:28
I assume you've already parsed the JSON from a string into JavaScript data types, so I've removed the references to JSON to avoid confusion. Feel free to roll back if that's not the case. (btw it's actually not even an object but an array of objects.) — JJJ
– JJJ, Commented Mar 24, 2013 at 16:31
Juhana, yes, I have already done that using $.parseJSON(data). — Astro
– Astro, Commented Mar 24, 2013 at 16:33

Adidi · Accepted Answer · 2013-03-24 16:41:30Z

2

There you go: http://jsfiddle.net/hezgb/

    var data = [ {"vid":"aaa", "san":12}, {"vid":"aaa", "san":18}, {"vid":"aaa", "san":2}, {"vid":"bbb", "san":33}, {"vid":"bbb", "san":44}, {"vid":"aaa", "san":100}];

function SerializeResults( inData ) {

    var map = {};
    $.each( inData, function( i, val ) {
         if(!map[val.vid]){
             var o = {};
             o.san = [];
             map[val.vid] = o;
         }
        else{
            var o = map[val.vid];
        }

        o.san.push(val.san);
    });
    var main = [];
    $.each( map, function( key, val ) {
        main.push({vid:key,san:val.san});  
    });

    return main;
}

console.log(SerializeResults(data));

answered Mar 24, 2013 at 16:41

Adidi

5,2835 gold badges27 silver badges30 bronze badges

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

Comments

nullSharp · Accepted Answer · 2013-03-24 16:49:49Z

1

How does this work for you?

http://jsfiddle.net/T7bZd/4/

    $.each( inData, function( i, val ) 
{
   if(typeof out[val.vid]==="undefined")
       out[val.vid] = new Array();
   out[val.vid].push(val.san);
});

answered Mar 24, 2013 at 16:49

nullSharp

3311 silver badge4 bronze badges

2 Comments

Bafsky Over a year ago

It is pretty, but doesn't give the results you asked for.

nullSharp Over a year ago

Yeah, I was hoping he could get away with something like this instead.

7zark7 · Accepted Answer · 2013-03-24 16:56:11Z

0

I am adding yet another answer as a form of punishment for you asking "how do I do that?" ;-)

var _ = require('underscore')
var json = '[ {"vid":"aaa", "san":12}, {"vid":"aaa", "san":18}, {"vid":"aaa", "san":2}, {"vid":"bbb", "san":33}, {"vid":"bbb", "san":44}, {"vid":"aaa", "san":100}]'

var grouped = _.groupBy(JSON.parse(json), function(z) {
  return z.vid
})

var result = _.pairs(grouped).map(function(item) {
  return { vid: item[0], san: _.pluck(item[1], 'san') }
})

answered Mar 24, 2013 at 16:56

7zark7

10.2k5 gold badges42 silver badges54 bronze badges

2 Comments

Astro Over a year ago

Never heard of require('underscore') before, thanks for sharing!

7zark7 Over a year ago

FYI, this is actually server-side JS (node.js)

Pang · Accepted Answer · 2019-07-26 01:57:40Z

0

Try this.

function SerializeResults( inData ) {
    var a = {};

    $.each(inData, function( i, val ) {
        var id = val['vid'];

        if (a[id]) {
            a[id]['san'].push(val['san']);
        } else {
            a[id] = {vid:id, san:[val['san']]};
        }
    });

    var aa = [];

    $.each(a, function(i, val) {
        aa.push(val);
    });

    return aa;
}

edited Jul 26, 2019 at 1:57

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Mar 24, 2013 at 16:47

Bafsky

7811 gold badge7 silver badges16 bronze badges

Collectives™ on Stack Overflow

Transform an Array of Objects

4 Answers 4

Comments

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related