Solved

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

Posted on 2015-01-26
3
127 Views
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
0
Comment
Question by:dentsplynz
3 Comments
 
LVL 42

Assisted Solution

by:Rob Jurd, EE MVE
Rob Jurd, EE MVE earned 250 total points
ID: 40571936
http://jsbin.com/nukawa/1/edit?html,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: obj.total});
}

console.dir(data);

Open in new window

0
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 250 total points
ID: 40572174
Hi,
and an alternative using the jQuery way utilizing the jQuery.map 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: element.total}});

Open in new window

Sample:
http://jsfiddle.net/EE_RainerJ/t21oasLa/

HTH
Rainer
0
 

Author Closing Comment

by:dentsplynz
ID: 40574525
Awesome! Thanks so much.
0

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

Introduction If you're like most people, you have occasionally made a typographical error when you're entering information into an online form.  And to your consternation, the browser remembers the error, and offers to autocomplete your future entr…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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)
The viewer will learn the basics of jQuery including how to code hide show and toggles. 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…

770 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