javascript pivot array of objects

Question

I need a little help to reorganize this array of objects:

[
  {employee: "PLUTO", "MON1": 6},
  {employee: "PLUTO", "TUE2": 6},
  //etc..
  {employee: "DONALD", "MON1":7},
  {employee: "DONALD", "TUE2":7},
  //etc...
]

I need to get a result like:

[
  {employee: "PLUTO", "MON1":6, "TUE2":6, "etc...."},
  {employee: "DONALD", "MON1":7, "TUE2",7", "etc..."}
]

I'm able to get only one object with reduce function to create a new object:

var test = myArr.reduce((acc, it) => Object.assign(acc, it), {});
console.log(test); 
[{employee: "DONALD", "MON1":7, "TUE2":7, "etc..."}] <--get only the last employee

Thank you in advance

Rajneesh · Accepted Answer · 2021-03-01 13:51:56Z

3

You can make use reduce to group the data by name and take Object.values in the last:

const arr = [
  {employee: "PLUTO", "MON1": 6},
  {employee: "PLUTO", "TUE2": 6},
  //etc..
  {employee: "DONALD", "MON1":7},
  {employee: "DONALD", "TUE2":7},
  //etc...
];


const result = arr.reduce((a,e)=>(a[e.employee]={...(a[e.employee] || {}), ...e}, a),{});

console.log(Object.values(result));

answered Mar 1, 2021 at 13:51

Rajneesh

5,3181 gold badge10 silver badges20 bronze badges

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

Comments

Abdul Haseeb · Accepted Answer · 2021-03-01 13:50:10Z

2

This should do it.

 myArr.reduce((acc,it)=>{
   const index = acc.map(i=>i.employee).indexOf(it.employee);
   if(index === -1)
     acc.push(it);
   else
     Object.assign(acc[index],it);
   return acc;
 },[])

answered Mar 1, 2021 at 13:50

Abdul Haseeb

3721 silver badge6 bronze badges

Collectives™ on Stack Overflow

javascript pivot array of objects

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related