How do I convert data from one format to another format using JavaScript/jQuery ?

Posted on 2015-01-26
Last Modified: 2015-01-27
I have a json_encoded data assigned to a js variable

var dataToConvert = [
{"department" : "IS & IT", "total" : "24239.50" },
{"department" : "Finance & Legal", "total" : "250.00"}

Open in new window

How do I convert the above data to the following format ?

var data = [
{value : 24239.50, label : "IS & IT"},
{value : 250.00, label : "Finance & Legal"}

Open in new window

This is to generate data dynamically for CharJS Pie Chart
Question by:dentsplynz
LVL 42

Assisted Solution

by:Rob Jurd, EE MVE
Rob Jurd, EE MVE earned 250 total points
ID: 40571936,js,console,output

var dataToConvert = [
  {"department" : "IS & IT", "total" : "24239.50" },
  {"department" : "Finance & Legal", "total" : "250.00"}

var data = [];

for (var i in dataToConvert) {
  var obj = dataToConvert[i];
  data.push({label: obj.department, value:});


Open in new window

LVL 44

Accepted Solution

Rainer Jeschor earned 250 total points
ID: 40572174
and an alternative using the jQuery way utilizing the function:
var dataToConvert = [
{"department" : "IS & IT", "total" : "24239.50" },
{"department" : "Finance & Legal", "total" : "250.00"}
var data = $.map(dataToConvert,function(element,index) {
    return {label: element.department, value:}});

Open in new window



Author Closing Comment

ID: 40574525
Awesome! Thanks so much.

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What is a Lightbox? A Lightbox is the effect you see when you click, for example, an image and the screen fades out and up pops the same image but in its full size dimensions. There are lots of Lightbox effects for jQuery. Problem is they are a…
Introduction A frequently asked question goes something like this:  "I am running a long process in the background and I want to alert my client when the process finishes.  How can I send a message to the browser?"  Unfortunately, the short answer …
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now