How to combine multiple JSON object that have same key and value

Question

How to combine JSON objects in the same response that has the same key and value with javascript? This is my data for example:

{
    "data": [
        {
            "name": "A",
            "description": {
                "location": "location1",
                "floor": "floor1",
            },
        },
        {
            "name": "A",
            "description": {
                "location": "location2",
                "floor": "floor1",
            },
        },
        {
            "name": "B",
            "description": {
                "location": "location3",
                "floor": "floor3",
            },
        },
    ]
}

And turn it into this:

{
    "data": [
        {
            "name": "A",
            "description": {
                "location": ["location1","location2"],
                "floor": "floor1",
            },
        },
        {
            "name": "B",
            "description": {
                "location": "location3",
                "floor": "floor3",
            },
        },
    ]
}

Basically I am someone who is new to learning javascript. Any help would be very helpful, thank you.

This is a poor question, you haven't even attempted to solve the problem. Please try to solve the problem, and ask for help in regard to what goes wrong with your approach. — HAK
– HAK, Commented Dec 15, 2022 at 9:13
There are lots of solved questions on here about "grouping" data too. — Andy
– Andy, Commented Dec 15, 2022 at 9:20
Yes, that's right, I haven't read much. Actually I'm confused about what's the right keywords for this that I can google it. But any help for now will certainly be very useful for me. Thank you also for telling me about "grouping data", after this I will learn more about it :) — stevart
– stevart, Commented Dec 15, 2022 at 9:33

Yosvel Quintero · Accepted Answer · 2022-12-15 10:00:06Z

1

You can do:

const data = {data: [{name: 'A',description: {location: 'location1',floor: 'floor1',},},{name: 'A',description: {location: 'location2',floor: 'floor1',},},{name: 'B',description: {location: 'location3',floor: 'floor3',},},],}

const result = {
  data: data.data.reduce((a, { name, description }) => {
    const index = a.findIndex((d) => d.name === name)
    if (index >= 0) {
      let location = a[index].description.location
      location = Array.isArray(location) ? location : [location]
      a[index].description.location = [...location, description.location]
    } else {
      a.push({ name, description })
    }
    return a
  }, []),
}

console.log(result)

answered Dec 15, 2022 at 10:00

Yosvel Quintero

19.1k5 gold badges39 silver badges47 bronze badges

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

Comments

ragulkumar · Accepted Answer · 2022-12-15 11:56:59Z

const list = {
    "data": [
        {
            "name": "A",
            "description": {
                "location": "location1",
                "floor": "floor1",
            },
        },
        {
            "name": "A",
            "description": {
                "location": "location2",
                "floor": "floor1",
            },
        },
        {
            "name": "B",
            "description": {
                "location": "location3",
                "floor": "floor3",
            },
        },
    ]
};


const consolidatedData = [];

for (const ele of list.data) {
    const isExist = consolidatedData.find(x => x.name === ele.name);

    if (!isExist) {
        consolidatedData.push({
            ...ele
        })
    } else {
        const objectKey = consolidatedData.findIndex(x => x.name === ele.name);
        if (objectKey > -1) {
            const description = consolidatedData[objectKey].description;
            const newDes = ele.description;

            if (newDes.location !== description.location) {
                const data = consolidatedData[objectKey].description;
                const added = [data.location, ele.description.location];
                delete consolidatedData[objectKey].description.location
                consolidatedData[objectKey].description["location"] = added
            }

            if (newDes.floor !== description.floor){
                const data = consolidatedData[objectKey].floor;
                const added = [data.floor, ele.description.floor];
                delete consolidatedData[objectKey].description.floor
                consolidatedData[objectKey].description["floor"] = added
            }

        }
    }
}

console.log(JSON.stringify(consolidatedData, null, 2));

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Peter Thoeny · Accepted Answer · 2022-12-15 19:16:37Z

Here is a solution that uses an intermediate bucket object. The desired result object is then constructed from the bucket object:

const input = { "data": [ { "name": "A", "description": { "location": "location1", "floor": "floor1", }, }, { "name": "A", "description": { "location": "location2", "floor": "floor1", }, }, { "name": "B", "description": { "location": "location3", "floor": "floor3", }, }, ] };

let buckets = input.data.reduce((acc, obj) => {
  if(!acc[obj.name]) {
    acc[obj.name] = {
      locations: {},
      floors: {}
    };
  }
  acc[obj.name].locations[obj.description.location] = true; 
  acc[obj.name].floors[obj.description.floor] = true; 
  return acc;
}, {});
console.log('buckets: ', buckets);

let result = {
  data: Object.keys(buckets).map(name => {
    let locations = Object.keys(buckets[name].locations);
    let floors = Object.keys(buckets[name].floors);
    return {
      name: name,
      description: {
        location: locations.length == 1 ? locations[0] : locations,
        floor: floors.length == 1 ? floors[0] : floors
      }
    }
  })
};
console.log('result:', result);

Notes:

buckets object:
- is created using an array .reduce()
- array .reduce() docs: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/reduce
- locations and floors are collected using objects instead of arrays, this is to avoid duplicate names
result object:
- is using Object.keys(buckets) to get the array of names
- .map() transforms each name into the desired object
- your unusual array or string value for location and floor is constructed with a conditional

Collectives™ on Stack Overflow

How to combine multiple JSON object that have same key and value

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related