JSon array dynamic column filling AngularJs

Question

I have an Object like this:

var myObject= [
{"name":'Tom', "city":'Chicago',"GroupCode":'1'}, 
{"name":'Harry', "city":'Wisconsin',"GroupCode":'1'}, 
{"name":'Rob', "city":'Los Angeles',"GroupCode":'2'}, 
{"name":'Peter', "city":'Seattle',"GroupCode":'2'}, 
{"name":'Dave', "city":'New York',"GroupCode":'3'}, 
{"name":'Steve', "city":'Boston',"GroupCode":'3}
];

transforming as

var myObject= [
    {"name":'Tom', "city":'Chicago',"GroupCode":'1'}, 
    {"name":'Harry', "city":'Wisconsin',"GroupCode":'1'}, 
    {"name":'--', "city":'--',"GroupCode":'--'}, 
    {"name":'Rob', "city":'Los Angeles',"GroupCode":'2'}, 
    {"name":'Peter', "city":'Seattle',"GroupCode":'2'}, 
    {"name":'--', "city":'--',"GroupCode":'--'}, 
    {"name":'Dave', "city":'New York',"GroupCode":'3'}, 
    {"name":'Steve', "city":'Boston',"GroupCode":'3} 
    ];

using the following code to add new records in between when ever GroupCode is changing:

var gc = myObject[0].GroupCode;
myObject.forEach(function(ob, index) {
  if (gc != ob.GroupCode) {
    gc = ob.GroupCode;
    //insert this object
    myObject.splice(index, 0, {
      "name": '--',
      "city": '--',
      "GroupCode": '--'
    });
  }
})

How can i make the keys/columns dynamic here ?

myObject.splice(index, 0, {
          "name": '--',
          "city": '--',
          "GroupCode": '--'
        });

Cyril Cherian · Accepted Answer · 2016-03-13 07:01:15Z

1

You can do it like this:

myObject.forEach(function(ob, index) {
  if (gc != ob.GroupCode) {
    gc = ob.GroupCode;
    keys = Object.keys(ob);
    var a = {};
    //dynamically creating keys in object
    a[keys[0]] = '--'
    a[keys[1]] = '--'
    a[keys[2]] = '--'
    //insert this object
    myObject.splice(index, 0, a);
  }

})

working code here

Or you can do it like this too making it more dynamic.

myObject.forEach(function(ob, index) {
  if (gc != ob.GroupCode) {
    gc = ob.GroupCode;
    keys = Object.keys(ob);
    var a = {};
    //iterate over  keys and make object
    keys.forEach(function(key){
      a[key] = '--'
      a[key] = '--'
      a[key] = '--'
    })
    //insert this object
    myObject.splice(index, 0, a);
  }

})

working code here

answered Mar 13, 2016 at 7:01

Cyril Cherian

32.4k7 gold badges48 silver badges57 bronze badges

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

1 Comment

hakuna Over a year ago

Thank you Cyril, That helped me.

Collectives™ on Stack Overflow

JSon array dynamic column filling AngularJs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related