Merge one JSON and JSON array on the basis of JSON's value and JSON Array's key

Question

I wanna try to create one JSON array in node by combine these two JSON and JSON arrays

`var template = {
    "key1": "value1",
    "key3": "value3",
    "key4": "value3",
    "key6": "Dummy Value1"
};
var data = [
  {
    "value1": "1",
    "value2": "2",
    "value3": "3"
  },
  {
    "value1": "11",
    "value2": "12",
    "value3": "13"
  },
  {
    "value1": "21",
    "value2": "22",
    "value3": "23"
  }
];`

I need Resulted JSON be like

var result = [
  {
    "key1": "1",
    "key3": "3",
    "key4": "3",
    "key6": "Dummy Value1"
  },
  {
    "key1": "11",
    "key3": "13",
    "key4": "13",
    "key6": "Dummy Value1"
  },
  {
    "key1": "21",
    "key3": "23",
    "key4": "23",
    "key6": "Dummy Value1"
  }
]

In my case there will be around 40 keys in JSON array and around 25 keys in template JSON, So I'm also looking for Optimized solution for this. Anybody can help me in this?

Where are the data inside the data array ? Why is there key1 : 1, key3 : 3, key4 :3 everywhere ? You just want to replace every data with the template ? — Weedoze
– Weedoze, Commented Nov 23, 2016 at 7:33
you sure. i think you want result like var result = [ { "key1": "1", "key3": "3", "key4": "3", "key6": "Dummy Value1" }, { "key1": "11", "key3": "13", "key4": "13", "key6": "Dummy Value1" }, { "key1": "21", "key3": "23", "key4": "23", "key6": "Dummy Value1" } ]? — Ashish Rajput
– Ashish Rajput, Commented Nov 23, 2016 at 7:33
Sorry,Yes ashish you are right.. i need to update my result JSON — Mayank Jain
– Mayank Jain, Commented Nov 23, 2016 at 7:35

Pranav C Balan · Accepted Answer · 2016-11-23 07:55:19Z

2

Use Array#map and Array#reduce methods.

// iterate over the array
var res = data.map(function(o) {
  // get the property names array and iterate to generate 
  // result object
  return Object.keys(template).reduce(function(obj, k) {
    // define property based on the array element object has 
    // the prefered property or not
    obj[k] = o.hasOwnProperty(template[k]) ? o[template[k]] : template[k];
    // return the object reference
    return obj;
    // set initial value as an empty object which is used as
    // the new array element 
  }, {});
});

var template = {
  "key1": "value1",
  "key3": "value3",
  "key4": "value3",
  "key6": "Dummy Value1"
};
var data = [{
  "value1": "1",
  "value2": "2",
  "value3": "3"
}, {
  "value1": "11",
  "value2": "12",
  "value3": "13"
}, {
  "value1": "21",
  "value2": "22",
  "value3": "23"
}];

var res = data.map(function(o) {
  return Object.keys(template).reduce(function(obj, k) {
    obj[k] = o.hasOwnProperty(template[k]) ? o[template[k]] : template[k];
    return obj;
  }, {});
});

console.log(res);

edited Nov 23, 2016 at 7:55

answered Nov 23, 2016 at 7:37

Pranav C Balan

115k25 gold badges172 silver badges195 bronze badges

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

2 Comments

Mayank Jain Over a year ago

Thanks Pranav C Balan :)

Pranav C Balan Over a year ago

@MayankJain : glad to help you :)

sabithpocker · Accepted Answer · 2016-11-23 07:39:29Z

1

You can use array map to do this.

var template = {
  "key1": "value1",
  "key3": "value3",
  "key4": "value3",
  "key6": "Dummy Value1"
};
var data = [{
  "value1": "1",
  "value2": "2",
  "value3": "3"
}, {
  "value1": "11",
  "value2": "12",
  "value3": "13"
}, {
  "value1": "21",
  "value2": "22",
  "value3": "23"
}];

result = data.map(function(i){
  var o = {};
  for (var key in template){
    o[key] = template[key] in i ? i[template[key]] : template[key];
    }
  return o;
});

console.log(result);
``

answered Nov 23, 2016 at 7:39

sabithpocker

15.6k1 gold badge44 silver badges77 bronze badges

Comments

Nina Scholz · Accepted Answer · 2016-11-23 08:02:36Z

You could iterate the given data array and the keys and map the result for a new array.

var template = { "key1": "value1", "key3": "value3", "key4": "value3", "key6": "Dummy Value1" },
    data = [{ "value1": "1", "value2": "2", "value3": "3" }, { "value1": "11", "value2": "12", "value3": "13" }, { "value1": "21", "value2": "22", "value3": "23" }],
    result = data.map(function (a) {
        var o = {};
        this.forEach(function (k) {
            o[k] = template[k] in a ? a[template[k]] : template[k];
        })
        return o;
    }, Object.keys(template));
	
console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

ES6

var template = { "key1": "value1", "key3": "value3", "key4": "value3", "key6": "Dummy Value1" },
    data = [{ "value1": "1", "value2": "2", "value3": "3" }, { "value1": "11", "value2": "12", "value3": "13" }, { "value1": "21", "value2": "22", "value3": "23" }],
    keys = Object.keys(template),
    result = data.map(a =>
        keys.reduce((o, k) => (t => Object.assign(o, { [k]: t in a ? a[t] : t }))(template[k]), {}));
	
console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Collectives™ on Stack Overflow

Merge one JSON and JSON array on the basis of JSON's value and JSON Array's key

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related