JS creating new object array using another object

Question

I have below object array

var testdata = [{
                 TYPE: 'type 1', Category: 'Booking', Count : 5
               },
               {
                 TYPE: 'type 2', Category: 'Booking', Count : 15
               },
               {
                 TYPE: 'type 1', Category: 'Planning', Count : 10
               },
               {
                 TYPE: 'type 3', Category: 'SALES', Count : 5
               }]

I want to group each category and then by type and count as below:

 var resultdata =
    {
     "Booking": {
       "type 1": 5,
       "type 2": 15
     },
    "Planning": {
       "type 1": 10
     },
    "SALES": {
       "type 3": 5
     },
    }

so far I have written bellow logic but it fails to give me expected result it is only adding the last values of each category

 $.each(testdata , function (key, value) {
            if(value.Category == "Booking"){
                bookingarray['Booking'] = {[value.TYPE]: value.Count}
            }            
         })

Carsten Løvbo Andersen · Accepted Answer · 2022-07-13 07:16:15Z

You could try something like this:

$.each(testdata, function(key, value) {
  if (!bookingarray[value.Category]) {
    bookingarray[value.Category] = {} // if example "Booking" does not exist in resultData, then create it
  }
  bookingarray[value.Category][value.TYPE] = value.Count
})

Demo

var testdata = [{
    TYPE: 'type 1',
    Category: 'Booking',
    Count: 5
  },
  {
    TYPE: 'type 2',
    Category: 'Booking',
    Count: 15
  },
  {
    TYPE: 'type 1',
    Category: 'Planning',
    Count: 10
  },
  {
    TYPE: 'type 3',
    Category: 'SALES',
    Count: 5
  }
]

var bookingarray = {};

$.each(testdata, function(key, value) {
  if (!bookingarray[value.Category]) {
    bookingarray[value.Category] = {}
  }
  bookingarray[value.Category][value.TYPE] = value.Count
})

console.log(bookingarray)

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

Tyler2P · Accepted Answer · 2022-07-13 16:08:40Z

1

const testdata = [
  {
    TYPE: 'type 1', Category: 'Booking', Count : 5
  }, {
    TYPE: 'type 2', Category: 'Booking', Count : 15
  }, {
    TYPE: 'type 1', Category: 'Planning', Count : 10
  }, {
    TYPE: 'type 3', Category: 'SALES', Count : 5
  }
];
    
let categories = new Set(testdata.map(t => t.Category));
let resultData = {};

categories.forEach(c => testdata.map(t => {
  if (t.Category === c) {
    if(resultData[c]) resultData [c][t.TYPE] = t.Count;
    else resultData = { ...resultData , [c]: { [t.TYPE]: t.Count } }; 
  }
}));

console.log(resultData);

edited Jul 13, 2022 at 16:08

Tyler2P

2,37030 gold badges26 silver badges34 bronze badges

answered Jul 13, 2022 at 7:32

Dinesh Shaw

135 bronze badges

1 Comment

Tyler2P Over a year ago

Your answer could be improved by adding more information on what the code does and how it helps the OP.

Collectives™ on Stack Overflow

JS creating new object array using another object

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related