array and object handling in javascript for getting highchart json data

Question

I have array structure of employee information in JavaScript

var emplyeeinfo=[{
    empNo: 12302,
    empId: '30984',
    empJobCategory: 'Designer',
  },
  {
    empNo: 14785,
    empId: '33420',
    empJobCategory: 'Associate Manager',
  },
  {
    empNo: 13710,
    empId: '32603',
    empJobCategory: 'Designer',
  },
  {
    empNo: 13783,
    empId: '32675',
    empJobCategory: 'Designer',
  },
  {
    empNo: 15069,
    empId: '33619',
    empJobCategory: 'Designer',
  },
  {
    empNo: 14285,
    empId: '33020',
    empJobCategory: 'Validator',
  },
  {
    empNo: 14476,
    empId: '33185',
    empJobCategory: 'Designer',
  }];

and want to build array from above information

var employeejob=[{'Designer':[12302,13710,13783,15069,14476]},
                    {'Associate Manager':[14785]},
                    {'Validator':'[14285]}
                    ];

I did not find any proper mechanism to build this array in JavaScript and from this array want to build following array for high-chart series

    var finalchart={series:[7,5,1,1], 
category:['Total','Designer','Associate Manager','Validator']};

Seems like some backend guy don't want to send the exact data. — Mr_Green
– Mr_Green, Commented Apr 12, 2016 at 7:15
@anagha affinity you can build object of employeejob and than loop through your main loop and add specefic property you need in employeejob — uzaif
– uzaif, Commented Apr 12, 2016 at 7:20

Mr_Green · Accepted Answer · 2016-04-12 08:43:48Z

3

Try this:

// Your new object
var obj = {};
// loop through the objects in array
employeeinfo.map(function(e){
   // check if the object is already created or not
   if(!obj[e.empJobCategory]){
       // if not created then initialize it as an array
       obj[e.empJobCategory] = [];
   }
   // push the new empNo in the created/present array
   obj[e.empJobCategory].push(e.empNo);
});

// see the output
console.dir(obj);

Working Fiddle

Can also be done using Array.reduce().

var obj = employeeinfo.reduce(function(p, c, i, a) {
  if (!p[c.empJobCategory]) {
    p[c.empJobCategory] = [];
  }
  p[c.empJobCategory].push(c.empNo);
  return p;
}, {});

console.dir(obj);

Working Fiddle

edited Apr 12, 2016 at 8:43

answered Apr 12, 2016 at 7:22

Mr_Green

42k48 gold badges171 silver badges277 bronze badges

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

Comments

Rajarshi Das · Accepted Answer · 2016-04-12 07:47:49Z

0

You can try another way

function groupBy( array , f )
{
  var groups = {};
  array.forEach( function( o )
  {
    var group = JSON.stringify( f(o) );
    groups[group] = groups[group] || [];
    groups[group].push( o.empNo );  
  });
  return Object.keys(groups).map( function( group )
  {
    return groups[group]; 
  })
}

Then

var result = groupBy(employeeinfo, function(item)
{
  return [item.empJobCategory];
});

The print

console.dir(result)

edited Apr 12, 2016 at 7:47

answered Apr 12, 2016 at 7:41

Rajarshi Das

12.4k7 gold badges53 silver badges88 bronze badges

Collectives™ on Stack Overflow

array and object handling in javascript for getting highchart json data

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