Convert nested array of objects to specific group of objects of the data in JavaScript or TypeScript

Question

I am having a double nested array of objects and I would like to change to a specific array of groups to support my table structure.

Below are my objects and the result I am expecting.

let newData = {
  data: {
    summary: [
      {
        code: "12",
        data: [
          {
            group: "Trade",
            currency: "CAD", //group1
            amount: "$3,443.00",
            total: 1
          },
          {
            group: "Trade",
            currency: "USD", //group2
            amount: "$0.00",
            total: 0
          },
          {
            group: "Commission",
            currency: "CAD", //group3
            amount: "$0.00",
            total: 0
          },
          {
            group: "Commission",
            currency: "USD", //group4
            amount: "$0.00",
            total: 0
          }
        ]
      },
      {
        code: "34",
        data: [
          {
            group: "Trade",
            currency: "CAD", //group1
            amount: "$343.00",
            total: 21
          },
          {
            group: "Trade",
            currency: "USD", //group2
            amount: "$40.00",
            total: 40
          },
          {
            group: "Commission",
            currency: "CAD", //group3
            amount: "$30.00",
            total: 30
          },
          {
            group: "Commission",
            currency: "USD", //group4
            amount: "$20.00",
            total: 20
          }
        ]
      }
    ]
  }
};



let result = [
{
    code: "12",
    TradeCAD:
    {
            group: "Trade",
            currency: "CAD", //group1
            amount: "$3,443.00",
            total: 1
          },
     TradeUSD:     
           {
            group: "Trade",
            currency: "USD", //group2
            amount: "$0.00",
            total: 0
          },
     CommissionCAD:     {
            group: "Commission",
            currency: "CAD", //group3
            amount: "$0.00",
            total: 0
          },
     CommissionUSD:     {
            group: "Commission",
            currency: "USD", //group4
            amount: "$0.00",
            total: 0
          }

       
  },
  {
    code: "34",
    TradeCAD:
    {
            group: "Trade",
            currency: "CAD", //group1
            amount: "$343.00",
            total: 21
          },
     TradeUSD:     
           {
            group: "Trade",
            currency: "USD", //group2
            amount: "$40.00",
            total: 40
          },
     CommissionCAD:     {
            group: "Commission",
            currency: "CAD", //group3
            amount: "$30.00",
            total: 30
          },
     CommissionUSD:     {
            group: "Commission",
            currency: "USD", //group4
            amount: "$20.00",
            total: 20
          }

       
  },
];

How I can iterate and change the whole object and If I do have a lot of data which is the best approach to follow to support fewer iterations?

Gustavo Lopes · Accepted Answer · 2020-12-18 18:35:57Z

2

try this, and see if work. you can condense the code into one function if you want to.

const result = newData.data.summary.map(item => {
  const res = {
    code: item.code,
  }
  item.data.forEach(d => {
    res[`${d.group}${d.currency}`] = d;
    d.amount = d.amount || "$0.00"; // default value for amount
    d.total = d.total || 0; // default value for total
  })
  return res;
});
console.log(JSON.stringify(result));

edited Dec 18, 2020 at 18:35

Gustavo Lopes

4,2534 gold badges24 silver badges63 bronze badges

answered Dec 17, 2020 at 21:07

D. Seah

4,7121 gold badge15 silver badges27 bronze badges

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

8 Comments

a.p. patel Over a year ago

It's working perfect thanks. Just a question.. how we can handle null check if the object is missing or any property is not there?

D. Seah Over a year ago

can you provide an example? :-)

a.p. patel Over a year ago

if this object is missing in code: "34", { group: "Trade", currency: "CAD", //group1 amount: "$343.00", total: 21 },

a.p. patel Over a year ago

or code: "34", missing group: "Trade" value

a.p. patel Over a year ago

How we can check this kind of scenario?

|

Collectives™ on Stack Overflow

Convert nested array of objects to specific group of objects of the data in JavaScript or TypeScript

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related