Merge JSON objects while retaining duplicate keys

Question

Merge JSON objects while retaining duplicate keys

I am looking to merge two arrays containing JSON objects while retaining duplicate keys by adding a prefix to the keys. In this specific scenario, the data from 'json2' is replacing the data from 'json1' due to having identical keys, but I want to keep both sets of data. Thank you.

var json1 = [
  {
    "Column1": "json1",
    "Column2": "json1",
  },
  {
    "Column1": "json1",
    "Column2": "json1",
  }
];
var json2 = [
  {
    "Column1": "json2",
    "Column2": "json2",
  },
  {
    "Column1": "json2",
    "Column2": "json2",
  }
];

console.log(angular.extend(json1, json2));

The current output is:

[
  {
    "Column1": "json2",
    "Column2": "json2",
  },
  {
    "Column1": "json2",
    "Column2": "json2",
  }
];

However, the desired output is:

[
  {
    "json1Column1": "json1",
    "json1Column2": "json1",
    "json2Column1": "json2",
    "json2Column2": "json2",
  },
  {
    "json1Column1": "json1",
    "json1Column2": "json1",
    "json2Column1": "json2",
    "json2Column2": "json2",
  }
];

javascript arrays angularjs json

Answer 1

Answer №1

To overcome the issue, consider creating a custom function to prefix objects:

function addPrefix(target, prefix){
    var newObj = false;
    if(target.constructor === Array){
        newObj = [];
        for(var i = 0 ; i< target.length; i++){
            item = target[i];
            var itemObj = {}; 
            for(var key in item){
                itemObj[prefix+key] = item[key]; 
            }
            newObj.push(itemObj);         
        }       
    }else{
        newObj = {};
        for(var key in target){
                newObj[prefix+key] = target[key]; 
        }
    }
     return newObj;
}

Instead of using angular.extend, utilize angular.merge for deep property copy. This will prevent properties from the second object being copied into the first. Once you have implemented the custom function, proceed with:

var nJson1=addPrefix(json1,"json1");
var nJson2=addPrefix(json2,"json2");
var merged = angular.merge({},nJson1,nJson2);

Answer 2

To overcome the issue, consider creating a custom function to prefix objects:

function addPrefix(target, prefix){
    var newObj = false;
    if(target.constructor === Array){
        newObj = [];
        for(var i = 0 ; i< target.length; i++){
            item = target[i];
            var itemObj = {}; 
            for(var key in item){
                itemObj[prefix+key] = item[key]; 
            }
            newObj.push(itemObj);         
        }       
    }else{
        newObj = {};
        for(var key in target){
                newObj[prefix+key] = target[key]; 
        }
    }
     return newObj;
}

Instead of using angular.extend, utilize angular.merge for deep property copy. This will prevent properties from the second object being copied into the first. Once you have implemented the custom function, proceed with:

var nJson1=addPrefix(json1,"json1");
var nJson2=addPrefix(json2,"json2");
var merged = angular.merge({},nJson1,nJson2);

Answer 3

Answer №2

An innovative solution involving iteration through keys and items.

const array1 = [{ Name: "John", Age: 25 }, { Name: "Alice", Age: 30 }],
    array2 = [{ City: "New York", Country: "USA" }, { City: "London", Country: "UK" }],
    mergedResult = function (data) {
        let finalArray = [];
        Object.keys(data).forEach(function (key) {
            data[key].forEach(function (item, index) {
                finalArray[index] = finalArray[index] || {};
                Object.keys(item).forEach(function (property) {
                    finalArray[index][key + property] = item[property];
                });
            });
        });
        return finalArray;
    }({ info1: array1, info2: array2 });

document.write('<pre>' + JSON.stringify(mergedResult, null, 4) + '</pre>');

Answer 4

An innovative solution involving iteration through keys and items.

const array1 = [{ Name: "John", Age: 25 }, { Name: "Alice", Age: 30 }],
    array2 = [{ City: "New York", Country: "USA" }, { City: "London", Country: "UK" }],
    mergedResult = function (data) {
        let finalArray = [];
        Object.keys(data).forEach(function (key) {
            data[key].forEach(function (item, index) {
                finalArray[index] = finalArray[index] || {};
                Object.keys(item).forEach(function (property) {
                    finalArray[index][key + property] = item[property];
                });
            });
        });
        return finalArray;
    }({ info1: array1, info2: array2 });

document.write('<pre>' + JSON.stringify(mergedResult, null, 4) + '</pre>');

Merge JSON objects while retaining duplicate keys

Answer №1

Answer №2

Similar questions

Struggling with serving static content on NodeJS using Express.js

The error callback in Jquery ajax is triggered despite receiving a 200 status code in the response

Upon initial page load, React JS is unable to fetch the data but it functions correctly when triggered by a click

Having trouble dynamically assigning the ng-model attribute

How to incorporate "selectAllow" when dealing with dates in FullCalendar

Is there a way to access the target element containing the ui-view attribute in ui-router when a state transition occurs?

Integration of AngularJS with PHP for Seamless User Authentication

Tips on implementing CSS to the subpar class in Vuejs

Retrieving multiple selected row values using an ASP Repeater

How can you display a set of components in React using TypeScript?

Click on the dropdown item in the Bootstrap btn-group dropdown

The Angular JS Factory fails to send data back to the controller

Move the modal dialog so it appears closer to the top of the page

How to update an array in MongoDB with PyMongo

Can the renderWith function of a column in angular-datatables retrieve a value from a promise?

Challenge encountered while processing JSON data

res.send No data being transmitted - in the realm of Express.js

The ExpressJS EJS issue arises when trying to access a property that is undefined

Attempting to concatenate a missing closing curly brace to an invalid JSON entity

When converting JSON to a pandas DataFrame in Python, all fields are displayed as type 'Object'