Group array of objects inside nested Array and add its total to a new Array [duplicate]

Question

I have an array of object with different tax rate and its value. I'm trying to combine all values with same tax rate into single object. Below is my code

const arr = [
  {
    "taxes": [
      {
        "name": "CGST 2.5%",
        "total": 4.01,
      },
      {
        "name": "SGST 2.5%",
        "total": 4.01,
      },
    ],
  },
  {
    "taxes": [
      {
        "name": "CGST 6%",
        "total": 10,
      },
      {
        "name": "SGST 6%",
        "total": 10,
      },
    ],
  },
  {
    "taxes": [
      {
        "name": "CGST 2.5%",
        "total": 16.42,
      },
      {
        "name": "SGST 2.5%",
        "total": 16.42,
      },
    ],
  },
  {
    "taxes": [
      {
        "name": "CGST 2.5%",
        "total": 0,
      },
      {
        "name": "SGST 2.5%",
        "total": 0,
      },
    ],
  },
  {
    "taxes": [
      {
        "name": "CGST 6%",
        "total": 12,
      },
      {
        "name": "SGST 6%",
        "total": 12,
      },
    ],
  },
];

const result = arr.map(item => {
    return Object.values(item.taxes.reduce((r, { name, total }) => {
        (r[name] || (r[name] = [name, 0]))[1] += total;
        return r;
    }, {}));
})

console.log(result);

I have searched and got reduce function which is working but I'm not able to make it to work with the nested arrays.

Kindly tolerate with my ability as I'm not at all familiar with the reduce function how it works.

What I wanted it will return me a new Array like

{ "CGST 2.5%": 20.43, "SGST 2.5%": 20.43, "CGST 6%": 22, "SGST 6%": 22 }

i think i have the problem with nested array. Can you point me to the right direction. I'll try the shared link — Atal Shrivastava
– Atal Shrivastava, Commented Apr 29, 2021 at 10:26
Have a look at this post too: Creating a SUM of nested object values in JavaScript. — Wais Kamal
– Wais Kamal, Commented Apr 29, 2021 at 10:32

boxdox · Accepted Answer · 2021-04-29 10:32:23Z

1

Simpler solution I can think of:

const result = {}
arr.forEach(el => {
  el.taxes.forEach(tax => {
    result[tax.name] = (result[tax.name] || 0)+ tax.total
  })
})
const solution = Object.entries(result).map(el => ({name: el[0], total: el[1]}))
console.log(solution)

answered Apr 29, 2021 at 10:32

boxdox

5722 silver badges8 bronze badges

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

Comments

Nur · Accepted Answer · 2021-04-29 10:49:33Z

1

@Atal Shrivastava, I appreciate your attempt, This is very simple solation, 1st check if entry exist or not, if not create entry else increase entry...

Code:

const arr = [{ "taxes": [{ "name": "CGST 2.5%", "total": 4.01 }, { "name": "SGST 2.5%", "total": 4.01 },] }, { "taxes": [{ "name": "CGST 6%", "total": 10, }, { "name": "SGST 6%", "total": 10 },] }, { "taxes": [{ "name": "CGST 2.5%", "total": 16.42 }, { "name": "SGST 2.5%", "total": 16.42 },] }, { "taxes": [{ "name": "CGST 2.5%", "total": 0, }, { "name": "SGST 2.5%", "total": 0, },] }, { "taxes": [{ "name": "CGST 6%", "total": 12, }, { "name": "SGST 6%", "total": 12 },] }];

const result = arr.reduce((result, { taxes }) => {
    for (const { name, total } of taxes)
        if (result[name])
            result[name] += total
        else
            result[name] = total

    return result;
}, {})

console.log(result);

edited Apr 29, 2021 at 10:49

answered Apr 29, 2021 at 10:41

Nur

2,5033 gold badges19 silver badges37 bronze badges

1 Comment

Atal Shrivastava Over a year ago

thanks for reply. I tried bocdox solution and it is working.

Collectives™ on Stack Overflow

Group array of objects inside nested Array and add its total to a new Array [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related