Merge and combine two JSON files

Question

Merge and combine two JSON files

My dilemma involves two JSON files:

F1_data.json:

{
    "A": {
        "time": "2015-11-26T08:20:15.130Z",
    },
    "B": {
        "time": "2015-11-26T08:30:19.432Z",   
    {
    "C": {
        "time": "2015-11-26T08:20:15.130Z",  
    }
}

F2_data.json:

[{
        "oaci": "A",
        "latitude": "45.979722222222",
        "longitude": "5.3377777777778"
    },
    {
        "oaci": "B",
        "latitude": "46.123333333333",
        "longitude": "5.8047222222222"
    },
    {
        "oaci": "C",
        "latitude": "47.123333333333",
        "longitude": "8.8047222222222"
    },

    {
        "oaci": "D",
        "latitude": "46.205555555556",
        "longitude": "5.2916666666667"
    }
]

My objective is to cross-check the "oaci" values and append latitude and longitude from F2_data.json into F1_data.json accordingly.

The desired output would be:

F1_data.json

{
    "A": {  
        "time": "2015-11-26T08:20:15.130Z",
         "latitude": "45.979722222222",
        "longitude": "5.3377777777778"
    },
    "B": {  
        "time": "2015-11-26T08:30:19.432Z", 
        "latitude": "46.123333333333",
        "longitude": "5.8047222222222"  
    {
    "C": {  
            "time": "2015-11-26T08:20:15.130Z", 
            "latitude": "47.123333333333",
            "longitude": "8.8047222222222" 
        }
}

I have begun working on this in JSON but welcome any pointers or assistance.

javascript json

Answer 1

Answer №1

Here is a sample code snippet in JavaScript:

var obj = {
    "A": {
        "time": "2015-11-26T08:20:15.130Z"
    },
    "B": {
        "time": "2015-11-26T08:30:19.432Z"   
    },
    "C": {
        "time": "2015-11-26T08:20:15.130Z" 
    }
}

var list = [
    {
        "oaci": "A",
        "latitude": "45.979722222222",
        "longitude": "5.3377777777778"
    },
    {
        "oaci": "B",
        "latitude": "46.123333333333",
        "longitude": "5.8047222222222"
    },
    {
        "oaci": "C",
        "latitude": "47.123333333333",
        "longitude": "8.8047222222222"
    },
    {
        "oaci": "D",
        "latitude": "46.205555555556",
        "longitude": "5.2916666666667"
    }
]

function getListItem(name){
    for(var i = 0; i < list.length; i++){
        if(list[i].oaci == name){
            return list[i];   
        }
    }
}

for(var prop in obj){
    var listItem = getListItem(prop);
    obj[prop].latitude = listItem.latitude;
    obj[prop].longitude = listItem.longitude;
}

console.log(JSON.stringify(obj, null, 2));

The final output from the above code:

{
  "A": {
    "time": "2015-11-26T08:20:15.130Z",
    "latitude": "45.979722222222",
    "longitude": "5.3377777777778"
  },
  "B": {
    "time": "2015-11-26T08:30:19.432Z",
    "latitude": "46.123333333333",
    "longitude": "5.8047222222222"
  },
  "C": {
    "time": "2015-11-26T08:20:15.130Z",
    "latitude": "47.123333333333",
    "longitude": "8.8047222222222"
  }
}

Answer 2

Here is a sample code snippet in JavaScript:

var obj = {
    "A": {
        "time": "2015-11-26T08:20:15.130Z"
    },
    "B": {
        "time": "2015-11-26T08:30:19.432Z"   
    },
    "C": {
        "time": "2015-11-26T08:20:15.130Z" 
    }
}

var list = [
    {
        "oaci": "A",
        "latitude": "45.979722222222",
        "longitude": "5.3377777777778"
    },
    {
        "oaci": "B",
        "latitude": "46.123333333333",
        "longitude": "5.8047222222222"
    },
    {
        "oaci": "C",
        "latitude": "47.123333333333",
        "longitude": "8.8047222222222"
    },
    {
        "oaci": "D",
        "latitude": "46.205555555556",
        "longitude": "5.2916666666667"
    }
]

function getListItem(name){
    for(var i = 0; i < list.length; i++){
        if(list[i].oaci == name){
            return list[i];   
        }
    }
}

for(var prop in obj){
    var listItem = getListItem(prop);
    obj[prop].latitude = listItem.latitude;
    obj[prop].longitude = listItem.longitude;
}

console.log(JSON.stringify(obj, null, 2));

The final output from the above code:

{
  "A": {
    "time": "2015-11-26T08:20:15.130Z",
    "latitude": "45.979722222222",
    "longitude": "5.3377777777778"
  },
  "B": {
    "time": "2015-11-26T08:30:19.432Z",
    "latitude": "46.123333333333",
    "longitude": "5.8047222222222"
  },
  "C": {
    "time": "2015-11-26T08:20:15.130Z",
    "latitude": "47.123333333333",
    "longitude": "8.8047222222222"
  }
}

Answer 3

Answer №2

To implement the timestamps object as t and the coordinate list as c, you can use the following code:

for (let timestamp in t) {
    for (let coordinate in c) {
        if (c[coordinate]["oaci"] === timestamp) {
            t[timestamp]["latitude"] = c[coordinate]["latitude"];
            t[timestamp]["longitude"] = c[coordinate]["longitude"];
        }
    }
}

Answer 4

To implement the timestamps object as t and the coordinate list as c, you can use the following code:

for (let timestamp in t) {
    for (let coordinate in c) {
        if (c[coordinate]["oaci"] === timestamp) {
            t[timestamp]["latitude"] = c[coordinate]["latitude"];
            t[timestamp]["longitude"] = c[coordinate]["longitude"];
        }
    }
}

Answer 5

Answer №3

If you have objects labeled as F1 and F2, this code snippet can help achieve the desired outcome:

F2.forEach(function(_data){
    var currentData = F1[_data.oaci];
    if (currentData) for (var prop in _data) if (prop !== 'oaci'){
        currentData[prop] = _data[prop];
    }
});

The final result will be stored within the F1 object.

This solution is designed to adapt dynamically, allowing for seamless operation even when additional properties are added to the objects.

Answer 6

If you have objects labeled as F1 and F2, this code snippet can help achieve the desired outcome:

F2.forEach(function(_data){
    var currentData = F1[_data.oaci];
    if (currentData) for (var prop in _data) if (prop !== 'oaci'){
        currentData[prop] = _data[prop];
    }
});

The final result will be stored within the F1 object.

This solution is designed to adapt dynamically, allowing for seamless operation even when additional properties are added to the objects.

Merge and combine two JSON files

Answer №1

Answer №2

Answer №3

Similar questions

Utilize JSON Arrays within a JSON structure when programming in Java

Using the `ssh2` module in Node.js without specifying a specific object

Using jQuery and Ajax to retrieve data from a PHP script's response

Tips for transferring the asp:Label ID from an asp:CheckBox

Looking for a jQuery plugin that creates a sticky top menu bar?

The single-page anchor link is positioned just below a few pixels, connecting with the #link

What methods and technologies are accessible for executing JavaScript through PHP?

Looking to minimize the amount of HTML code in Angularjs by utilizing ng-repeat

Integrating CSS with Material-UI in a React project: A step-by-step guide

Changing a string into a JavaScript date object

Unable to start node.js server to upload file in node with express and multer

Flask template fails to render following a redirect

After the JavaScript calculation is completed, the following display may show a value of NaN

The collaboration of TypeScript and Vue in implementing index signatures resulted in the TS7053 specification

Trouble initializing Google Maps in an Angular directive

Providing optimal image dimensions based on the size of the viewing window

What are the steps to set up Redis Store in my production environment?

Retrieving specific properties from a JSON object and logging them

The error message "Property 'destroy' of undefined cannot be read in DataTables"

Creating multiple countdowns in AngularJS using ng-repeat is a handy feature to have