How to calculate each object in the array in separate array?

Question

I have this array

bidsList = [
    {
      supplierName:'A',
      awardedCapacity:5,
    },
    {
      supplierName:'B',
      awardedCapacity:10,
    },
    {
      supplierName:'A',
      awardedCapacity:5,
    },
    {
      supplierName:'A',
      awardedCapacity:3,
    },
    {
      supplierName:'B',
      awardedCapacity:5,
    },
    {
      supplierName:'C',
      awardedCapacity:2,
    },

i need to have separete array where when i make the iteration throught this array i will calculate the total of all awardedCapacities where the supplier name is same

For example i should have array where i will have this output

 let newArr = [
    {
      supplierName: 'A',
      totalAwarded: 13,
    },
    {
      supplierName:'B',
      totalAwarded: 15,
    },
    {
      supplierName:'C',
      totalAwarded: 2,
    }
  ]

because on previous array i had three objects where the supplierName was A and when i sum their awarded capacities i am geetting 13 in the other object with it's supplier name

Mamun · Accepted Answer · 2021-11-23 11:10:11Z

3

You can try using Array.prototype.reduce() like the following way:

let bidsList = [
    {
      supplierName:'A',
      awardedCapacity:5,
    },
    {
      supplierName:'B',
      awardedCapacity:10,
    },
    {
      supplierName:'A',
      awardedCapacity:5,
    },
    {
      supplierName:'A',
      awardedCapacity:3,
    },
    {
      supplierName:'B',
      awardedCapacity:5,
    },
    {
      supplierName:'C',
      awardedCapacity:2,
    }
  ];
  
let newArr = [];
bidsList.reduce(function(acc, val) {
  if (!acc[val.supplierName]) {
    acc[val.supplierName] = { supplierName: val.supplierName, awardedCapacity: 0 };
    newArr.push(acc[val.supplierName])
  }
  acc[val.supplierName].awardedCapacity += val.awardedCapacity;
  return acc;
}, {});

console.log(newArr);

answered Nov 23, 2021 at 11:10

Mamun

69k9 gold badges51 silver badges62 bronze badges

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

2 Comments

user17190872 Over a year ago

thank you. Btw how can be this solved with for loop ?

user17190872 Over a year ago

@Mamum can you take a look please at my other question stackoverflow.com/questions/70080974/…

user17487781 · Accepted Answer · 2021-11-23 11:13:59Z

2

Array.reduce

    const newArr = bidsList.reduce((a, o) =>  {  
      const index  = a.findIndex(x => x.supplierName === o.supplierName);
      const s = a[index > -1 ? index: a.push({supplierName:o.supplierName, awardedCapacity:0}) - 1];
      s.awardedCapacity += o.awardedCapacity;
      return a;
    }, [])

answered Nov 23, 2021 at 11:13

user17487781

1 Comment

user17190872 Over a year ago

@Hary stackoverflow.com/questions/70080974/…

Azad · Accepted Answer · 2021-11-23 12:18:05Z

0

Use Array.reduce method

var bidsList = [
    {
      supplierName:'A',
      awardedCapacity:5,
    },
    {
      supplierName:'B',
      awardedCapacity:10,
    },
    {
      supplierName:'A',
      awardedCapacity:5,
    },
    {
      supplierName:'A',
      awardedCapacity:3,
    },
    {
      supplierName:'B',
      awardedCapacity:5,
    },
    {
      supplierName:'C',
      awardedCapacity:2,
    }];

var result = bidsList.reduce((a, c) => {

  let supplier = a.find(e => e.supplierName == c.supplierName);
  if (supplier)
    supplier.totalAwarded += c.awardedCapacity;
  else 
    a.push({
      supplierName: c.supplierName,
      totalAwarded: c.awardedCapacity
    });
  
  return a;
}, []);

console.log(result);

answered Nov 23, 2021 at 12:18

Azad

5,2725 gold badges31 silver badges59 bronze badges

1 Comment

user17190872 Over a year ago

can you take al ook at my other question please stackoverflow.com/questions/70080974/…

Collectives™ on Stack Overflow

How to calculate each object in the array in separate array?

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related