Combining two objects by id and grouping identical key-value pairs together

Question

Combining two objects by id and grouping identical key-value pairs together

      var routePlan = [
      {
        "id" : 1,
        "farmerName" : "Farmer1",
        "farmerId" : 1
      },
      {
        "id" : 2,
        "farmerName" : "Farmer2",
        "farmerId" : 2
      },
      {
        "id" : 1,
        "farmerName" : "Farmer3",
        "farmerId" : 3
      }
    ];

I'm looking to consolidate objects with the same id into a single combined object using either javascript or angularjs.

      var routePlan = [
      {
        "id" : 1,
        "farmers" : [
          {
            "farmerName" : "Farmer1",
            "farmerId" : 1
          },
          {
            "farmerName" : "Farmer3",
            "farmerId" : 3
          }
        ]
      },
      {
        "id" : 2,
        "farmerName" : "Farmer3",
        "farmerId" : 2
      }
    ];

I've searched online for examples, but haven't found one that fits my specific needs. Any help would be appreciated!

javascript

Answer 1

Answer №1

There is definitely room for improvement, but here is a functional solution:

let temporary = routePlan.reduce(function(accumulator, item){
    accumulator[item.id] = accumulator[item.id] || [];
    accumulator[item.id].push({ "farmerName": item.farmerName, "farmerId" : item.farmerId });
    return accumulator;
}, {});

let updatedRoute = Object.keys(temporary).map(function(key){ 
    let newObject = {}

    if (temporary[key].length > 1){
        newObject.id = parseInt(key);
        newObject.farmers = temporary[key];
    }
    else
    {
        newObject = Object.assign({}, routePlan.find(element => element.id == key));
    }

    return newObject;
});

Take note of the reduce function being used to group your objects by id.

Answer 2

There is definitely room for improvement, but here is a functional solution:

let temporary = routePlan.reduce(function(accumulator, item){
    accumulator[item.id] = accumulator[item.id] || [];
    accumulator[item.id].push({ "farmerName": item.farmerName, "farmerId" : item.farmerId });
    return accumulator;
}, {});

let updatedRoute = Object.keys(temporary).map(function(key){ 
    let newObject = {}

    if (temporary[key].length > 1){
        newObject.id = parseInt(key);
        newObject.farmers = temporary[key];
    }
    else
    {
        newObject = Object.assign({}, routePlan.find(element => element.id == key));
    }

    return newObject;
});

Take note of the reduce function being used to group your objects by id.

Answer 3

Answer №2

If you want to organize data into groups, consider using a hash table for reference.

var info = [{ id: 1, farmerName: "Farmer1", farmerId: 1 }, { id: 2, farmerName: "Farmer2", farmerId: 2 }, { id: 1, farmerName: "Farmer3", farmerId: 3 }],
    hashTable = Object.create(null),
    groupedData = info.reduce(function (result, item) {
        function getData(obj) {
            return ['farmerName', 'farmerId'].reduce(function (res, key) {
                res[key] = obj[key];
                return res;
            }, {});
        }
        if (!(item.id in hashTable)) {
            hashTable[item.id] = result.push(item) - 1;
            return result;
        }
        if (!result[hashTable[item.id]].farmers) {
            result[hashTable[item.id]] = { id: item.id, farmers: [getData(result[hashTable[item.id]])] };
        }
        result[hashTable[item.id]].farmers.push(getData(item));
        return result
    }, []);

console.log(groupedData);

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

Answer 4

If you want to organize data into groups, consider using a hash table for reference.

var info = [{ id: 1, farmerName: "Farmer1", farmerId: 1 }, { id: 2, farmerName: "Farmer2", farmerId: 2 }, { id: 1, farmerName: "Farmer3", farmerId: 3 }],
    hashTable = Object.create(null),
    groupedData = info.reduce(function (result, item) {
        function getData(obj) {
            return ['farmerName', 'farmerId'].reduce(function (res, key) {
                res[key] = obj[key];
                return res;
            }, {});
        }
        if (!(item.id in hashTable)) {
            hashTable[item.id] = result.push(item) - 1;
            return result;
        }
        if (!result[hashTable[item.id]].farmers) {
            result[hashTable[item.id]] = { id: item.id, farmers: [getData(result[hashTable[item.id]])] };
        }
        result[hashTable[item.id]].farmers.push(getData(item));
        return result
    }, []);

console.log(groupedData);

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

Combining two objects by id and grouping identical key-value pairs together

Answer №1

Answer №2

Similar questions

Could you share the most effective method for implementing a live search feature using javascript or jquery?

Tips for adding JSON values to an object

What is the recommended way to configure the build.gradle file for the app build process?

A label in nativescript not displaying a two-digit number

The NetSuite https.post() method is throwing an error that reads "Encountered unexpected character while parsing value: S. Path '', line 0, position 0"

Implementing the React Router into a ReactJS project: Methods to prevent users from clicking on links within React-Router's <Link> component

Tips for showcasing an array in nested elements within an Angular mat-tree

Having difficulty accessing the ::after element on Firefox when attempting to click

Can I deactivate JavaScript on my website directly from my server settings?

Tips for displaying personalized error messages from your REST API in a JavaScript client

"Turn a blind eye to Restangular's setRequestInterceptor just this

Using knex.js to pipe data to an express server

Build a nested block containing a div, link, and image using jQuery or vanilla JavaScript

How can I dynamically retrieve the width of an image in React as the screen size changes?

What is the best way to insert a permanent script tag into the body of a Gatsby site? Can conditional rendering be used to control

Automatically launching a new tab upon page load in a React application

What is the method for retrieving the XMLHttpRequest errors registered with addEventListener?

Tips on placing an li element into a designated DIV

The absence of the function crypto.createPrivateKey is causing issues in a next.js application

Struggling to make image uploading function with Flask and JQuery