Sum values for multiple objects in the array

Question

This is what I have:

const arrayA = [{name:'a', amount: 10, serviceId: '23a', test:'SUCCESS'},
                {name:'a', amount: 9, test:'FAIL'}, 
                {name:'b', amount: 15, serviceId: '23b', test:'SUCCESS'}]

(note that there's object not having 'serviceId')

I would like to get:

 [{name:'a', amount: 19, test:'FAIL'},
  {name:'b', amount: 15, test:'SUCCESS'}]

I want to sum amount field grouped by name.
'test' field should be FAIL if there's any object with the value FAIL (grouped by name)
I don't care about the value of serviceId and don't want to include it in the new object.

I have searched, and tried something like this: (reference: https://stackoverflow.com/a/50338360/13840216)

const result = Object.values(arrayA.reduce((r, o) => (r[o.name]
  ? (r[o.name].amount += o.amount)
  : (r[o.name] = {...o}), r), {}));

but still not sure how to assign test field.

Any help would be appreciated!

Nina Scholz · Accepted Answer · 2020-12-03 09:20:02Z

5

You need to check test and update the value, if necessary.

const
    array = [{ name: 'a', amount: 10, serviceId: '23a', test: 'SUCCESS' }, { name: 'a', amount: 9, test: 'FAIL' }, { name: 'b', amount: 15, serviceId: '23b', test: 'SUCCESS' }],
    result = Object.values(array.reduce((r, { name, amount, test }) => {
        if (!r[name]) r[name] = { name, amount: 0, test };
        r[name].amount += amount;
        if (test === 'FAIL') r[name].test = 'FAIL';
        return r;
    }, {}));

console.log(result);

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

answered Dec 3, 2020 at 9:20

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

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

Comments

mplungjan · Accepted Answer · 2020-12-03 09:40:05Z

2

This? Just test if the .test is already fail

const arrayA = [{ name: 'a', amount: 10, serviceId: '23a', test: 'SUCCESS' }, { name: 'a', amount: 9, test: 'FAIL' }, { name: 'b', amount: 15, serviceId: '23b', test: 'SUCCESS' }],
  result = Object.values(
    arrayA.reduce((r, o) => {
      r[o.name] ? (r[o.name].amount += o.amount) : (r[o.name] = { ...o })
      r[o.name].test = r[o.name].test === "FAIL" ? "FAIL" : o.test;
      return r;
    }, {})
  );

console.log(result);

edited Dec 3, 2020 at 9:40

answered Dec 3, 2020 at 9:24

mplungjan

180k29 gold badges183 silver badges246 bronze badges

Comments

mplungjan · Accepted Answer · 2020-12-03 10:26:06Z

1

Store the sums and final values in an object and then convert them into an array.

const arrayA = [
  { name: "a", amount: 10, serviceId: "23a", test: "SUCCESS" },
  { name: "a", amount: 9, test: "FAIL" },
  { name: "b", amount: 15, serviceId: "23b", test: "SUCCESS" },
];

const map = {};

arrayA.forEach((row) => {
  if (!map[row.name]) {
    map[row.name] = { name: row.name, amount: 0, test: "SUCCESS" };
  }

  map[row.name].amount += row.amount;

  if (row.test === "FAIL") {
    map[row.name].test = "FAIL";
  }
});

const result = Object.values(map);

console.log(result);

edited Dec 3, 2020 at 10:26

mplungjan

180k29 gold badges183 silver badges246 bronze badges

answered Dec 3, 2020 at 9:25

Abir Taheer

2,8533 gold badges16 silver badges39 bronze badges

1 Comment

mplungjan Over a year ago

Reduce removes the need to assign an object and then run values - you are still looping twice, but I removed the downvote

marc_s · Accepted Answer · 2020-12-08 21:49:13Z

That is a nice use case of how to process data in js, particularly how functions like map and reduce can help you do that processing. Which are a nice alternative to loops and iterations.

Moreover, I'd advise you to do the processing in steps, as you have defined in the description. For example:

const arrayA = [
    {name:'a', amount: 10, serviceId: '23a', test:'SUCCESS'},
    {name:'a', amount: 9, test:'FAIL'},
    {name:'b', amount: 15, serviceId: '23b', test:'SUCCESS'}
]

// First group the items by name
const byName = arrayA.reduce((ob, item) => {
    if(!(item.name in  ob))
        ob[item.name] = []
    ob[item.name].push({amount: item.amount, test: item.test})
    return ob
}, {})

// Then compute the total amount in each group and find if there is any FAIL in a group
const sumByName = Object.keys(byName).map(name => { // This is a way to iterate through the groups
    // Sum the amount in all elements of a group
    const amount = byName[name].reduce((sum, item) => sum + item.amount , 0)
    // Find if there is any FAIL in a group
    const test = byName[name].map(item => item.test) // Get an array with only the test string
        .includes('FAIL') ? 'FAIL': 'SUCCESS' // Evaluate if the array includes FAIL
    return ({name, amount, test})
})

console.log(sumByName)

Finally, I'd advise you to watch these videos on map and reduce (and all the content of that channel for this matter)

Reduce
Map

Alan Omar · Accepted Answer · 2020-12-03 10:01:16Z

0

you can use Array.reduce method:

const arrayA=[{name:"a",amount:10,serviceId:"23a",test:"SUCCESS"},{name:"a",amount:9,test:"FAIL"},{name:"b",amount:15,serviceId:"23b",test:"SUCCESS"}];

let result  = arrayA.reduce((aac,{name,amount,test}) => {
    let idx = aac.findIndex(n => n.name === name)
    if( idx != -1){
        aac[idx].amount += amount;
        if(test === "FAIL")
            aac[idx].test = "FAIL"        
        return aac
    }
    aac.push({name,amount,test})
    return aac
},[])

console.log(result);
console.log(arrayA)

answered Dec 3, 2020 at 10:01

Alan Omar

4,2771 gold badge13 silver badges26 bronze badges

Collectives™ on Stack Overflow

Sum values for multiple objects in the array

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related