Using Javascript, it is possible to generate a new JSON object through manipulation of an already

Question

Using Javascript, it is possible to generate a new JSON object through manipulation of an already

I have a JSON object that I am manipulating to create a new JSON object. The challenge lies in dynamically constructing a part of the JSON object. Below is the original JSON object:

[{"acptFlag":true,"count":14288,"limsFlag":true,"plantId":30,"plantName":"Camilla, GA","supplierId":20,"supplierName":"Keystone Foods"},{"acptFlag":false,"count":344,"limsFlag":true,"plantId":30,"plantName":"Camilla, GA","supplierId":20,"supplierName":"Keystone Foods"},{"acptFlag":false,"count":700,"limsFlag":true,"plantId":31,"plantName":"Albany, KY","supplierId":20,"supplierName":"Keystone Foods"},{"acptFlag":true,"count":9500,"limsFlag":true,"plantId":31,"plantName":"Albany, KY","supplierId":20,"supplierName":"Keystone Foods"},{"acptFlag":false,"count":227,"limsFlag":true,"plantId":32,"plantName":"Green Forest, AR","supplierId":21,"supplierName":"Tyson Foods"},{"acptFlag":true,"count":7049,"limsFlag":true,"plantId":32,"plantName":"Green Forest, AR","supplierId":21,"supplierName":"Tyson Foods"},{"acptFlag":true,"count":10742,"limsFlag":true,"plantId":33,"plantName":"Dawson, GA","supplierId":21,"supplierName":"Tyson Foods"},{"acptFlag":false,"count":506,"limsFlag":true,"plantId":33,"plantName":"Dawson, GA","supplierId":21,"supplierName":"Tyson Foods"}]

The desired JSON object is as follows:

[{"supplierName":"Keystone Foods","1":(344/(344+14288)) , "2":700/(700+9500))}},{"supplierName":"Tyson Foods"","1":(227/(227+7049)) , "2":(506/(506+10742))}}]

Here, I am attempting to group data for each supplier into a single object. In

"1":(344/(344+14288)) , "2":700/(700+9500))

, false count/true count ratio is represented by "1" and "2" signifies the count of plants. Confusion arises in constructing the plant count code.

Below is my existing code:

var resultJSON = {}, arr = [];
var jsonObj = JSON.parse(obj)
for (var key in jsonObj) {
  if (jsonObj.hasOwnProperty(key)) {
    var val = jsonObj[key];
    var supplierName = val.supplierName;
    arr.push(supplierName);    
  }
}
var M = {}, R = []
getUniqueSuppliers(arr)
function getUniqueSuppliers(arr) {
   for(var i = 0; i < arr.length; i++) {
      M[arr[i]] = "supplierName"
   }
  for(var i in M) {
    R.push(i)
  }
}
checkEachSupplier(R)
function checkEachSupplier(R) { 
    for (var index = 0; index < R.length; index++) {
       var supplierName = R[index]
       createNewJSON(supplierName)
   }
}
getPlantTotalValueBasedOnSupplier(R);
function createNewJSON(supplierName) {

    for (var key in jsonObj) {
       if (jsonObj.hasOwnProperty(key)) {
       var val = jsonObj[key];    
       if(supplierName == val.supplierName) {       
         resultJSON[supplierName] = {"supplierName" : supplierName}
       }
     }
   }
 }
 console.log(resultJSON)

Link to my JSON fiddle: https://jsfiddle.net/7u5qphx9/6/

javascript json

Answer 1

Answer №1

Perhaps this information can be useful.

To handle the count, a temporary object named temp is used.

{
    "Keystone Foods": {
        "30": {
            "true": 14288,
            "false": 344
        },
        "31": {
            "false": 700,
            "true": 9500
        }
    },
    "Tyson Foods": {
        "32": {
            "false": 227,
            "true": 7049
        },
        "33": {
            "true": 10742,
            "false": 506
        }
    }
}

The code breakdown:

temp = obj1.reduce(function (r, a) {
    // ...
    return r;
}, {}),

This usage of Array.prototype.reduce() involves iterating over obj1, initializing with an empty object and returning results in each iteration.

r[a.supplierName] = r[a.supplierName] || {};

A compact way to create a new object if it doesn't exist already.

{
    "Keystone Foods": {}
}

r[a.supplierName][a.plantId] = r[a.supplierName][a.plantId] || {};

Similar logic for creating objects based on plant ID.

{
    "Keystone Foods": {
        "30": {}
    }
}

r[a.supplierName][a.plantId][a.acptFlag] = a.count;

Assigning the count value under the respective acptFlag property.

{
    "Keystone Foods": {
        "30": {
            "true": 14288
    },
}

With the object setup done, the next focus shifts for constructing a new array containing desired objects o.

obj2 = Object.keys(temp).map(function (k) {
    // ...
    return o;
});

Initially extracting all keys from temp followed by mapping to form a fresh array.

Within the callback function

var o = { supplierName: k };

Creating a new object with supplier name key and current key's value.

Object.keys(temp[k]).forEach(function (kk, i) {
    // ...
});

Further iteration to access the nested keys for plant IDs.

o[i + 1] = '' + temp[k][kk].false + ' / (' + temp[k][kk].false + ' + ' + temp[k][kk].true + ')';

For each plantID, setting up a new property with values representing true and false properties, represented as strings. (Can be adjusted to numbers using

o[i + 1] = temp[k][kk].false / (temp[k][kk].false + temp[k][kk].true);

).

var obj1 = [{...}]; 

document.write('<pre>' + JSON.stringify(temp, 0, 4) + '</pre>');
document.write('<pre>' + JSON.stringify(obj2, 0, 4) + '</pre>');

Answer 2

Perhaps this information can be useful.

To handle the count, a temporary object named temp is used.

{
    "Keystone Foods": {
        "30": {
            "true": 14288,
            "false": 344
        },
        "31": {
            "false": 700,
            "true": 9500
        }
    },
    "Tyson Foods": {
        "32": {
            "false": 227,
            "true": 7049
        },
        "33": {
            "true": 10742,
            "false": 506
        }
    }
}

The code breakdown:

temp = obj1.reduce(function (r, a) {
    // ...
    return r;
}, {}),

This usage of Array.prototype.reduce() involves iterating over obj1, initializing with an empty object and returning results in each iteration.

r[a.supplierName] = r[a.supplierName] || {};

A compact way to create a new object if it doesn't exist already.

{
    "Keystone Foods": {}
}

r[a.supplierName][a.plantId] = r[a.supplierName][a.plantId] || {};

Similar logic for creating objects based on plant ID.

{
    "Keystone Foods": {
        "30": {}
    }
}

r[a.supplierName][a.plantId][a.acptFlag] = a.count;

Assigning the count value under the respective acptFlag property.

{
    "Keystone Foods": {
        "30": {
            "true": 14288
    },
}

With the object setup done, the next focus shifts for constructing a new array containing desired objects o.

obj2 = Object.keys(temp).map(function (k) {
    // ...
    return o;
});

Initially extracting all keys from temp followed by mapping to form a fresh array.

Within the callback function

var o = { supplierName: k };

Creating a new object with supplier name key and current key's value.

Object.keys(temp[k]).forEach(function (kk, i) {
    // ...
});

Further iteration to access the nested keys for plant IDs.

o[i + 1] = '' + temp[k][kk].false + ' / (' + temp[k][kk].false + ' + ' + temp[k][kk].true + ')';

For each plantID, setting up a new property with values representing true and false properties, represented as strings. (Can be adjusted to numbers using

o[i + 1] = temp[k][kk].false / (temp[k][kk].false + temp[k][kk].true);

).

var obj1 = [{...}]; 

document.write('<pre>' + JSON.stringify(temp, 0, 4) + '</pre>');
document.write('<pre>' + JSON.stringify(obj2, 0, 4) + '</pre>');

Using Javascript, it is possible to generate a new JSON object through manipulation of an already

Answer №1

Similar questions

Decoding JSON Arrays with Newtonsoft in C#

What is the best way to submit a form and display results without refreshing the page?

Associating the object key and value with distinct attributes within the component

looking to showcase the highest 'levelNumber' of elements within an array

Proper method of defining an action in Vuex

Tips for updating the value of a key in a JavaScript object when the TextField tag's value changes

Is there a way to make the fixed table header scroll along with the table body data?

Combining a JSON object with a regular string in Python

Ways to retrieve JSON information and incorporate it into an if statement in this specific scenario

What is the most effective method for identifying duplicate values in a multidimensional array using typescript or javascript?

Is it possible to save an entire webpage that infinitely scrolls without actually manually scrolling through it?

What is the best way to incorporate a <c:forEach> loop into JSP operations?

What is the best way to append these values to an array?

Unable to modify the properties of a stateless child component

Javascript text validation is malfunctioning as the alert message fails to appear

Using JavaScript to display dynamic data pulled from Django models

Improving React code by using conditional statements such as IF and Else

Creating a link button using JavaScript

Tips for displaying a digital keyboard when a webpage loads on iOS Safari

Tips for efficiently resolving and compiling a bug within an NPM package, ensuring it is accessible to the build server