Mapping between 2 json files in AngularJs

Question

Which is the best method for the mapping between 2 JSON files in angularJs I want to map beteween 2 JSON files and displayed it in my table.

JSON 1

[{
    "year": 2013,  
    "doctor": "Dr. Smith", 
    "illness": "Flu", 
    "apptdate": "3/12/2013",
    "details":"Patient had flu for 5 days. No medicines prescribed"
}, {
    "year": 2014,  
    "doctor": "Dr. ram", 
    "illness": "fever", 
    "apptdate": "31/12/2014",
    "details":"Patient had flu for 5 days. No medicines prescribed"
}, {
    "year": 2015,  
    "doctor": "Dr. rom", 
    "illness": "headache", 
    "apptdate": "3/12/2015",
    "details":"Patient had flu for 5 days. No medicines prescribed"
}, {
    "year": 2016,  
    "doctor": "Dr. zen", 
    "illness": "fever", 
    "apptdate": "21/12/2016",
    "details":"Patient had flu for 5 days. No medicines prescribed"
}]

JSON 2

[{
    "year": 2013,  
    "cost": 260
}, {
    "year": 2014,  
    "cost": 360
}, {
    "year": 2015,  
    "cost": 102
}, {
    "year": 2016,  
    "cost": 180
}]

I want to map these files based on the year , and displayed it in my smart-table. Which is the best solution for this problem?

So you need to populate first json with the "cost" data for particular years? — Artem Arkhipov
– Artem Arkhipov, Commented Sep 27, 2017 at 11:36

M0nst3R · Accepted Answer · 2017-09-27 11:48:32Z

1

You can easily achieve this by using map, assign and find :

function merge(json1, json2) {
    if (!json1 || !json1.length || !json2 || !json2.length) {
        return [];
    }
    return json1.map((current) => {
        return Object.assign(current, json2.find((el) => {
            return el.year === current.year;
        }));
    });
}

answered Sep 27, 2017 at 11:48

M0nst3R

5,3131 gold badge28 silver badges39 bronze badges

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

Comments

Maxim Shoustin · Accepted Answer · 2017-09-27 11:54:15Z

0

You can use loadash:

var result = _.map(a, function(item) {
    return _.merge(item, _.find(b, ['year', item.year]));
});

By using map, find and merge

Demo Fiddle

Output:

[
  {
    "year": 2013,
    "doctor": "Dr. Smith",
    "illness": "Flu",
    "apptdate": "3/12/2013",
    "details": "Patient had flu for 5 days. No medicines prescribed",
    "cost": 260
  },
...
]

If you don't need cost, replace _.merge with _.assign a.e.

var result = _.map(a, function(item) {
    return _.assign(item, _.find(b, ['year', item.year]));
});

edited Sep 27, 2017 at 11:54

answered Sep 27, 2017 at 11:48

Maxim Shoustin

78k29 gold badges212 silver badges229 bronze badges

Comments

Abhishek Singh · Accepted Answer · 2017-09-27 13:06:08Z

0

Below code can be utilised for merging two json:

function merge(obj) {
    var sources = [].slice.call(arguments, 1);
    sources.forEach(function (source) {
      for (var prop in source) {
        target[prop] = source[prop];
      }
    });
    return obj;
}

var result = merge({}, json1, json2);

edited Sep 27, 2017 at 13:06

answered Sep 27, 2017 at 13:00

Abhishek Singh

2,73717 silver badges24 bronze badges

Comments

raosaeedali · Accepted Answer · 2017-09-28 10:30:18Z

0

Merging two JSON Objects:

var o1 = { a: 1 };
var o2 = { b: 2 };
var o3 = { c: 3 };

var obj = Object.assign(o1, o2, o3);
console.log(obj); // { a: 1, b: 2, c: 3 }
console.log(o1);  // { a: 1, b: 2, c: 3 }, target object itself is changed.

Merging with same properties:

var o1 = { a: 1, b: 1, c: 1 };
var o2 = { b: 2, c: 2 };
var o3 = { c: 3 };

var obj = Object.assign({}, o1, o2, o3);
console.log(obj); // { a: 1, b: 2, c: 3 }

Source

answered Sep 28, 2017 at 10:30

raosaeedali

1138 bronze badges

Collectives™ on Stack Overflow

Mapping between 2 json files in AngularJs

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related