Combining two JSON datasets using specific fields in Javascript

Question

Combining two JSON datasets using specific fields in Javascript

Two JSON inputs are provided:

[
  {
    userId: 32159,
    userFirstName: "john",
    userLastName: "doe",
    plans: [ ]
  },
  {
    userId: 32157,
    userFirstName: "dave",
    userLastName: "mess",
    plans: [ ]
  }
]

and

[
      {
        userId: 32159,
        userFirstName: "john",
        userLastName: "doe",
        results: [ ]
      },
      {
        userId: 32157,
        userFirstName: "dave",
        userLastName: "mess",
        results: [ ]
      }
]

I require the following combined output:

[
      {
        userId: 32159,
        userFirstName: "john",
        userLastName: "doe",
        plans: [ ],
        results: [ ]
      },
      {
        userId: 32157,
        userFirstName: "dave",
        userLastName: "mess",
        plans: [ ],
        results: [ ]
      }
 ]

Seeking assistance to achieve this in JavaScript. The 'userId' field is unique in this case.

javascript json

Answer 1

Answer №1

One approach to achieve object extension is by iterating through a collection, selecting the corresponding object, and extending it. Here's an example:

var array1 = [], array2 = [],
    finalArray = [];

$.each(array1, function(index1, obj1) {
    $.each(array2, function(index2, obj2) {
        if (obj1.userId === obj2.userId) {
            finalArray.push($.extend({}, obj1, obj2));
            return false;
        }
    });
});

console.log(finalArray);

Answer 2

One approach to achieve object extension is by iterating through a collection, selecting the corresponding object, and extending it. Here's an example:

var array1 = [], array2 = [],
    finalArray = [];

$.each(array1, function(index1, obj1) {
    $.each(array2, function(index2, obj2) {
        if (obj1.userId === obj2.userId) {
            finalArray.push($.extend({}, obj1, obj2));
            return false;
        }
    });
});

console.log(finalArray);

Answer 3

Answer №2

To achieve this, you can utilize the underscore-min.js file and implement the following code snippet using its built-in functions:

 _.each(json1, function(data1) {
    _.each(json2, function(data2) {
            if (data1.userId = data2.userId) {
                _.extend(data1, data2.results);
            }
        }

    })

  });

Answer 4

To achieve this, you can utilize the underscore-min.js file and implement the following code snippet using its built-in functions:

 _.each(json1, function(data1) {
    _.each(json2, function(data2) {
            if (data1.userId = data2.userId) {
                _.extend(data1, data2.results);
            }
        }

    })

  });

Answer 5

Answer №3

If you're looking to achieve this using just JavaScript, here is one approach you can take.

function duplicate(obj1, obj2) {
    for (var key in obj1)
        if (obj1.hasOwnProperty(key))
            obj2[key] = obj1[key];
}

function combineArrays(arr1, arr2) {
    var finalArray = [];

    for (var i = 0; i < arr1.length; i++) {
        finalArray.push({});
        duplicate(arr1[i], finalArray[i]);
    }

    for (var j = 0; j < arr2.length; j++)
        duplicate(arr2[j], finalArray[j]);

    return finalArray;
}

combineArrays(yourfirstarray, yoursecondarray);

Answer 6

If you're looking to achieve this using just JavaScript, here is one approach you can take.

function duplicate(obj1, obj2) {
    for (var key in obj1)
        if (obj1.hasOwnProperty(key))
            obj2[key] = obj1[key];
}

function combineArrays(arr1, arr2) {
    var finalArray = [];

    for (var i = 0; i < arr1.length; i++) {
        finalArray.push({});
        duplicate(arr1[i], finalArray[i]);
    }

    for (var j = 0; j < arr2.length; j++)
        duplicate(arr2[j], finalArray[j]);

    return finalArray;
}

combineArrays(yourfirstarray, yoursecondarray);

Answer 7

Answer №4

The concept you're looking for is known as Concurrent Processing in Functional Programming. You have two sets of data that need to be processed simultaneously in order to achieve a desired result. The code snippet provided below demonstrates this process:

http://repl.it/Ll1/1

// Array Array -> Array
// Assume that the length of array A is equal to the length of array B
// and the items are sorted correctly to align their records
function zip(a, b) {
    // Object Object -> Object
    function combineResults(itemA, itemB) {
        itemA["results"] = itemB["results"];
        return itemA;
    }
    
    if (a.length === 0) {
        return [];
    } else {
        return [combineResults(a[0], b[0])].concat(zip(a.slice(1), b.slice(1)));
    }
}

zip(a, b);

Answer 8

The concept you're looking for is known as Concurrent Processing in Functional Programming. You have two sets of data that need to be processed simultaneously in order to achieve a desired result. The code snippet provided below demonstrates this process:

http://repl.it/Ll1/1

// Array Array -> Array
// Assume that the length of array A is equal to the length of array B
// and the items are sorted correctly to align their records
function zip(a, b) {
    // Object Object -> Object
    function combineResults(itemA, itemB) {
        itemA["results"] = itemB["results"];
        return itemA;
    }
    
    if (a.length === 0) {
        return [];
    } else {
        return [combineResults(a[0], b[0])].concat(zip(a.slice(1), b.slice(1)));
    }
}

zip(a, b);

Answer 9

Answer №5

To streamline the process, I suggest breaking down the tasks into specific functions:

function mergeObjects(firstObj, secondObj) {
  if (firstObj && secondObj) { for (var key in secondObj) { firstObj[key] = secondObj[key]; } }
  return firstObj;
}

function mergeAndSortArrays(arr1, arr2) {
    return arr1
        .concat(arr2)
        .sort(function (a, b) { return a.userId - b.userId; });
}

function combineArrays(arr1, arr2) {
    var mergedArr = mergeAndSortArrays(arr1, arr2);
    for (var i = 0, len = mergedArr.length - 1; i < len; i++) {
        if (mergedArr[i].userId === mergedArr[i+1].userId) {
            mergedArr[i] = mergeObjects(mergedArr[i], mergedArr[i+1]);
            mergedArr.splice(i+1, 1);
            i--; len--;
        }
    }
    return mergedArr;
}

combineArrays(arr1, arr2);

Answer 10

To streamline the process, I suggest breaking down the tasks into specific functions:

function mergeObjects(firstObj, secondObj) {
  if (firstObj && secondObj) { for (var key in secondObj) { firstObj[key] = secondObj[key]; } }
  return firstObj;
}

function mergeAndSortArrays(arr1, arr2) {
    return arr1
        .concat(arr2)
        .sort(function (a, b) { return a.userId - b.userId; });
}

function combineArrays(arr1, arr2) {
    var mergedArr = mergeAndSortArrays(arr1, arr2);
    for (var i = 0, len = mergedArr.length - 1; i < len; i++) {
        if (mergedArr[i].userId === mergedArr[i+1].userId) {
            mergedArr[i] = mergeObjects(mergedArr[i], mergedArr[i+1]);
            mergedArr.splice(i+1, 1);
            i--; len--;
        }
    }
    return mergedArr;
}

combineArrays(arr1, arr2);

Answer 11

Answer №6

Utilizing jQuery's extend method:

var data1 = [{
    id: 32159,
    firstName: "alice",
    lastName: "smith",
    info: []
}, {
    id: 32157,
    firstName: "bob",
    lastName: "jones",
    info: []
}];

var data2 = [{
    id: 32157,
    firstName: "bob",
    lastName: "jones",
    details: []
}, {
    id: 32159,
    firstName: "alice",
    lastName: "smith",
    details: []
}];

var mergedData = [];

for (i = 0; i < data1.length; i++) {
    for (j = 0; j < data2.length; j++) {
        if (data1[i].id == data2[j].id) 
            mergedData.push($.extend(data1[i], data2[j]));
    }
}

console.log(mergedData);

Fiddle here

Answer 12

Utilizing jQuery's extend method:

var data1 = [{
    id: 32159,
    firstName: "alice",
    lastName: "smith",
    info: []
}, {
    id: 32157,
    firstName: "bob",
    lastName: "jones",
    info: []
}];

var data2 = [{
    id: 32157,
    firstName: "bob",
    lastName: "jones",
    details: []
}, {
    id: 32159,
    firstName: "alice",
    lastName: "smith",
    details: []
}];

var mergedData = [];

for (i = 0; i < data1.length; i++) {
    for (j = 0; j < data2.length; j++) {
        if (data1[i].id == data2[j].id) 
            mergedData.push($.extend(data1[i], data2[j]));
    }
}

console.log(mergedData);

Fiddle here

Combining two JSON datasets using specific fields in Javascript

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Answer №6

Similar questions

Activate an event on a separate webpage using jQuery or JavaScript

The Vue component does not render the JS Promise and instead displays it as

Having trouble receiving response from retrofit v2 call

Using AJAX and jQuery for database connectivity allows for seamless data retrieval and manipulation

What is the best way to create a timer using JavaScript?

Django not receiving data from AJAX GET request

Jackson Mixin: for deserializing route identifiers

Setting an interval for a specific function to trigger after a delay of 5 seconds

What is the best way to respond to a hashchange event within AngularJs?

Typescript: Determine when a property should be included depending on the value of another property

Cannot instantiate Marker Clusterer as a constructor

Obtain information about a div element while scrolling

React Material-UI Table Cell departure event

Is it secure to store information that impacts component rendering within a JWT payload?

What is the best way to implement a gradual decrease in padding as the viewport resizes using JavaScript

Use ajax to add rows to the second-to-last table

Replacements of JSON null values within Mantle

Prevent the Stop Button from triggering submission and then utilize JavaScript to submit the form

Invoking WinJS.Binding.List.createFiltered with an asynchronous call to the predicate function

Replicate the anchor's functionality (opening in a new window when 'ctl' is pressed) when submitting a form