How to combine two json properties into one array

Question

I have a json data like this:

var data = [{
    "RM_Name": "Cloud Strife",
    "Division": "Avalanche",
    "RM_Phone": "No Phone",
    "RC_Name": "No RM",
    "RC_Phone": "No Phone",
    "States_Covered": "Midgar,Nibelheim"
}, {
    "RM_Name": "Clint Eastwood",
    "Division": "Hollywood",
    "RM_Phone": "No Phone",
    "RC_Name": "No RC",
    "RC_Phone": "No Phone",
    "States_Covered": "Gran Torino"
}, {
    "RM_Name": "Barret Wallace",
    "Division": "Avalanche",
    "RM_Phone": "No Phone",
    "RC_Name": "Barry Allen",
    "RC_Phone": "No Phone",
    "States_Covered": "North Corel"
}, {
    "RM_Name": "Tifa Lockheart",
    "Division": "Avalanche",
    "RM_Phone": "No Phone",
    "RC_Name": "Aeris Gainsborough",
    "RC_Phone": "No Phone",
    "States_Covered": "Sector 7"
}];

Now I want to create a new array consist of RM_Name and RC_Name like this so the output would be like this:

[Cloud Strife,Clint Eastwood,Barret Wallace,Barry Allen,Tifa Lockheart,Aeris Gainsborough]

How can I do that? I have tried using $.merge(). But I think the output is wrong. Any help is greatly appreciated.

Your example does not include the No RM and No RC entries, should these be ignored? — Rory McCrossan
– Rory McCrossan, Commented May 6, 2014 at 9:43
@RoryMcCrossan yes just ignore it i just need to see how to combine both properties :) — a_miguel6687
– a_miguel6687, Commented May 6, 2014 at 9:45

Kiran · Accepted Answer · 2014-05-06 09:57:16Z

3

Use jQuery .each() to iterate JSON. Try this:

var dataArray = [];
$.each(data, function(i, v){
       dataArray.push(v.RM_Name);
       if(v.RC_Name !="No RC")
       dataArray.push(v.RC_Name);
});
console.log(dataArray);

DEMO FIDDLE

edited May 6, 2014 at 9:57

answered May 6, 2014 at 9:46

Kiran

20.3k11 gold badges72 silver badges101 bronze badges

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

Comments

Bhavik · Accepted Answer · 2014-05-06 09:51:54Z

2

Demo Fiddle
jQuery

var toShow = new Array();
$.each(data,function(i,item){
    toShow.push(item.RM_Name);
    if(item.RC_Name !="No RC")
        toShow.push(item.RC_Name);
});

It would even ignore each "RC_Name":"No RC"

Hope it helps...

answered May 6, 2014 at 9:51

Bhavik

4,9044 gold badges32 silver badges45 bronze badges

Comments

Andrei · Accepted Answer · 2014-05-06 09:52:40Z

2

Doing it without jQuery and ignoring No RC and No RM.

Demo Fiddle

var result = [];
for(var i = 0, l = data.length; i < l; ++i)
{
    if(data[i].RM_Name !== 'No RM')
       result.push(data[i].RM_Name);
    if(data[i].RC_Name !== 'No RC')
       result.push(data[i].RC_Name);
}
console.log(result);

What this does is:

loop over the data array
if the RC_Name is different than 'No RC' push it in the array
if the RM_name is different than 'No RM' push it in the array
output the array

edited May 6, 2014 at 9:52

answered May 6, 2014 at 9:46

Andrei

3,0862 gold badges21 silver badges24 bronze badges

Comments

Josh Mc · Accepted Answer · 2014-05-06 10:13:34Z

2

Functional options (No Jquery) ~ Both IE9+ only without poly-fill.

var ar = data.reduce(function(previous, current)
{ 
    previous.push(current.RM_Name, current.RC_Name);  
    return previous;
}, []);

or (although not overly readable)

var ar = Array.prototype.concat.apply([], data.map(function(row){ 
    return [row.RM_Name, row.RC_Name]; 
}));

edited May 6, 2014 at 10:13

answered May 6, 2014 at 9:50

Josh Mc

10.3k8 gold badges57 silver badges68 bronze badges

3 Comments

Andrei Over a year ago

reduce is kinda of new, not supported in older browsers without polyfill. developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/…

VisioN Over a year ago

@JoshMc Same refers to Array.prototype.map as well.

Josh Mc Over a year ago

Get so used to including a polyfill, you forget which ones are for what browsers ^^.

Sudharsan S · Accepted Answer · 2014-05-06 10:12:22Z

1

Use .each() in jquery

var name = [];
$.each(data, function( index, value ) {
        name.push(value.RM_Name);
        if(value.RC_Name !="No RC")
        name.push(value.RC_Name);  
});

console.log(name);

edited May 6, 2014 at 10:12

answered May 6, 2014 at 9:46

Sudharsan S

15.4k4 gold badges34 silver badges51 bronze badges

Comments

VisioN · Accepted Answer · 2014-05-06 10:05:01Z

0

Another possible solution with $.map and $.grep:

[].concat.apply($.map(data, function(o) {
    return $.grep([o.RM_Name, o.RC_Name], function(v) {
        return v !== 'No RM' && v !== 'No RC';
    });
}));

You may omit the $.grep part if you don't need to filter properties by value:

[].concat.apply($.map(data, function(o) {
    return [o.RM_Name, o.RC_Name];
}));

answered May 6, 2014 at 10:05

VisioN

146k35 gold badges287 silver badges291 bronze badges

Collectives™ on Stack Overflow

How to combine two json properties into one array

6 Answers 6

Comments

Comments

Comments

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related