Find matching object property in array and merge into new object [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 2 years ago.

Improve this question

I have an array of objects, where I want to find the objects having same value for name property and then merge them into single object by adding their values & subvalues.

const arr = [
 { id: 1, name: 'a', value: 2, subvalue: 3 }, 
 { id: 2, name: 'b', value: 4, subvalue: 3 },
 { id: 3, name: 'c', value: 4, subvalue: 3 },
 { id: 4, name: 'b', value: 3, subvalue: 4 } 
]

Expected output

[
 { id: 1, name: 'a', value: 2, subvalue: 3 }, 
 { id: 2, name: 'b', value: 7, subvalue: 7 },
 { id: 3, name: 'c', value: 4, subvalue: 3 }
]

The id of the new object can either be 2 or it can be 4. So it doesn't matter much. I have tried using filter, but not able to find a solution which suits my requirement

Does this answer your question? Most efficient method to groupby on an array of objects — pilchard
– pilchard, Commented May 1, 2023 at 9:56
or Javascript array of objects group and sum items or Grouping an Array and then summing values or How to group by and sum an array of objects javascript? — pilchard
– pilchard, Commented May 1, 2023 at 9:59

cmgchess · Accepted Answer · 2023-05-01 08:59:26Z

2

you can use reduce to group by name and then get the values array of the grouped object using Object.values

const arr = [
 { id: 1, name: 'a', value: 2, subvalue: 3 }, 
 { id: 2, name: 'b', value: 4, subvalue: 3 },
 { id: 3, name: 'c', value: 4, subvalue: 3 },
 { id: 4, name: 'b', value: 3, subvalue: 4 } 
]

const res = Object.values(arr.reduce((acc,curr) => {
  if(!acc[curr.name]){
    acc[curr.name] = curr
  } else {
    acc[curr.name].value += curr.value
    acc[curr.name].subvalue += curr.subvalue
  }
  return acc
},{}))

console.log(res)

or the whole if else logic be one-lined but less readable

const arr = [
 { id: 1, name: 'a', value: 2, subvalue: 3 }, 
 { id: 2, name: 'b', value: 4, subvalue: 3 },
 { id: 3, name: 'c', value: 4, subvalue: 3 },
 { id: 4, name: 'b', value: 3, subvalue: 4 } 
]

const res = Object.values(arr.reduce((acc, curr) => {
    acc[curr.name] = acc[curr.name] ? {...acc[curr.name], value: acc[curr.name].value + curr.value, subvalue: acc[curr.name].subvalue + curr.subvalue} : curr
    return acc
}, {}))

console.log(res)

edited May 1, 2023 at 8:59

answered May 1, 2023 at 8:45

cmgchess

10.3k42 gold badges55 silver badges70 bronze badges

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

1 Comment

pilchard Over a year ago

You really posted a new group by answer?

TAHER El Mehdi · Accepted Answer · 2023-05-01 08:56:00Z

Using only Array#reduce, see if the name of the current object is already present in the accumulator with Array#findIndex, then Values and Subvalues should be accumulated respectively with the current object Values and Subvalues, Otherwise add the current object in the accumulator:

const arr = [ { id: 1, name: 'a', value: 2, subvalue: 3 }, { id: 2, name: 'b', value: 4, subvalue: 3 }, { id: 3, name: 'c', value: 4, subvalue: 3 }, { id: 4, name: 'b', value: 3, subvalue: 4 } ];
const result = arr.reduce((acc, cur) => {
  const index = acc.findIndex((obj) => obj.name === cur.name);
  if (index !== -1) {
    acc[index] = {
      ...acc[index],
      value: acc[index].value + cur.value,
      subvalue: acc[index].subvalue + cur.subvalue,
    };
  } else {
    acc.push(cur);
  }
  return acc;
}, []);
console.log(result);

if you don't want to maintain the first (original) id and would rather use the id from the last (most recent) merged object, just replace ...acc[index] with ...cur when you merge them.

Collectives™ on Stack Overflow

Find matching object property in array and merge into new object [closed]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related