Geek asks and answers

Denormalize an array of objects into a denormalized array

I am trying to find a way to denormalize an array of objects in JavaScript to get a set of arrays. I need this structure for a table (denormalized dataset).

So, given the input:

var data = [
    { v1: 1, v2: [ { a: 1 }, { a: 2 } ] },
    { v1: 2, v2: [ { a: 3 }, { a: 4 } ], v3: 5 },
];

I need a structure like

var data2 = [
    { v1: 1, v2_a: 1 },
    { v1: 1, v2_a: 2 },
    { v1: 2, v2_a: 3, v3: 5 },
    { v1: 2, v2_a: 4, v3: 5 }
];

The recursive path.

My first attempt was to do a full depth scan scan by adding properties to a temporary variable:

var result = [];
function aArray(data) {
    for(var i = 0; i < data.length; i++){
        var temp = {};
        for(var prop in data[i]){
            var val = data[i][prop];
            if( Object.prototype.toString.call( val ) === '[object Array]' ) {
                aArray(val);
            }else{
                temp[prop] = val;
            }
        }
        result.push(temp);
    }
}

But something is not working properly

+3
source share
1 answer

You can try this solution

var data = [
    { v1: 1, v2: [ { a: 1 }, { a: 2 } ] },
    { v1: 2, v2: [ { a: 3 }, { a: 4 } ], v3: 5 },
];

function is_a(a){
  return (typeof a == "object") && (a instanceof Array);
}
function extend(a, b){
  for(var i in b){
    a[i] = b[i];
  }
  return a;
}

Now the main logic is here:

var p = data.map(function(item){

  var output = {};
  var list   = [];

  for(var i in item){
    if(is_a(item[i])){
      for(var j = 0; j < item[i].length; j++){
        for(var z in item[i][j]){
          var k = {}; k[i + "_" + z] = item[i][j][z];
          list.push(k);
        }
      }
    }
    else{
      output[i] = item[i];
    }
  }    

  for(var i = 0; i < list.length; i++){
    list[i] = extend(list[i], output);
  }

  console.log(list);

});

Conclusion: First

0: Object v1: 1 v2_a: 1

1: Object v1: 1 v2_a: 2

Second

0: Object v1: 2 v2_a: 3 v3: 5

1: Object v1: 2 v2_a: 4 v3: 5

Try the demo

+1
source

More articles:


All Articles