Transform object into distinct entities based on their individual key value pairs

Question

Transform object into distinct entities based on their individual key value pairs

Here is my unique combined entity:

{
      "levelId-0":1,
      "level-0":"1",
      "levelpoints-0": 15,      
      "levelId-1":2,
      "level-1":"2",
      "levelpoints-1": 15,
      "levelId-2":3,
      "level-2":"3",
      "levelpoints-2": 15,
      "levelId-3":4,
      "level-3":"4",
      "levelpoints-3": 15,
      "medalId-0":1,
      "medalName-0":"Bronze",
      "medalsPoint-0":2020,
      "medalId-1":2,
      "medalName-1":"Silver",
      "medalsPoint-1":10,      
      "medalId-2":3,
      "medalName-2":"Gold",
      "medalsPoint-2":10,
      "medalId-3":1003,
      "medalName-3":"Platinum",
      "medalsPoint-3":85
   }

Desired Outcome:

      {
        "Level":[
          {
            "levelId":1,
            "level":"1",
            "points":2020
          },
          {
            "levelId":2,
            "level":"2",
            "points":1000
          }
        ],
        "Medal":[
          {
            "medalId":1,
            "medalName":"Bronze",
            "points":2020
          },
          {
            "medalId":3,
            "medalName":"Gold",
            "points":1000
          }
        ]
      }

Is there anyone who can assist me with this? I have attempted various methods without success. I looked into this solution: SO

javascript typescript loops

Answer 1

Answer №1

To extract the keys of the outer objects and parse the key of the provided data into a property and an index for assignment, you can follow this approach:

var data = { "levelId-0": 1, "level-0": "1", "levelpoints-0": 15, "levelId-1": 2, "level-1": "2", "levelpoints-1": 15, "levelId-2": 3, "level-2": "3", "levelpoints-2": 15, "levelId-3": 4, "level-3": "4", "levelpoints-3": 15, "medalId-0": 1, "medalName-0": "Bronze", "medalsPoint-0": 2020, "medalId-1": 2, "medalName-1": "Silver", "medalsPoint-1": 10, "medalId-2": 3, "medalName-2": "Gold", "medalsPoint-2": 10, "medalId-3": 1003, "medalName-3": "Platinum", "medalsPoint-3": 85 },
    result = Object.entries(data).reduce((o, [k, v]) => {
        var key = ['Level', 'Medal'].find(s => k.includes(s.toLowerCase())),
            [prop, index] = k.split('-');

        o[key] = o[key] || [];
        o[key][index] = o[key][index] || {};
        o[key][index][prop] = v;
        return o;
    }, {});

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Answer 2

To extract the keys of the outer objects and parse the key of the provided data into a property and an index for assignment, you can follow this approach:

var data = { "levelId-0": 1, "level-0": "1", "levelpoints-0": 15, "levelId-1": 2, "level-1": "2", "levelpoints-1": 15, "levelId-2": 3, "level-2": "3", "levelpoints-2": 15, "levelId-3": 4, "level-3": "4", "levelpoints-3": 15, "medalId-0": 1, "medalName-0": "Bronze", "medalsPoint-0": 2020, "medalId-1": 2, "medalName-1": "Silver", "medalsPoint-1": 10, "medalId-2": 3, "medalName-2": "Gold", "medalsPoint-2": 10, "medalId-3": 1003, "medalName-3": "Platinum", "medalsPoint-3": 85 },
    result = Object.entries(data).reduce((o, [k, v]) => {
        var key = ['Level', 'Medal'].find(s => k.includes(s.toLowerCase())),
            [prop, index] = k.split('-');

        o[key] = o[key] || [];
        o[key][index] = o[key][index] || {};
        o[key][index][prop] = v;
        return o;
    }, {});

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Answer 3

Answer №2

var info = {
  "levelId-0": 1,
  "level-0": "1",
  "levelpoints-0": 15,

  "levelId-1": 2,
  "level-1": "2",
  "levelpoints-1": 15,

  "levelId-2": 3,
  "level-2": "3",
  "levelpoints-2": 15,

  "levelId-3": 4,
  "level-3": "4",
  "levelpoints-3": 15,

  "medalId-0": 1,
  "medalName-0": "Bronze",
  "medalsPoint-0": 2020,

  "medalId-1": 2,
  "medalName-1": "Silver",
  "medalsPoint-1": 10,

  "medalId-2": 3,
  "medalName-2": "Gold",
  "medalsPoint-2": 10,

  "medalId-3": 1003,
  "medalName-3": "Platinum",
  "medalsPoint-3": 85
};

console.log(Object.entries(
  Object.keys(info).reduce(
    (output, key) => {
      let group = key.slice(-1);
      if(key.startsWith("level") && !(!((output["level"][group] = output["level"][group] || {})[key] = info[key])){
      key.startsWith("medal")) !== (!(output["medal"][group] = output["medal"][group] || {})[key] = info[key]);
        return output;
    },
    { level: {}, medal: {} }
  )
).reduce((output, item) => (p[item[0]] = Object.values(item[1]),p),{}));

Answer 4

var info = {
  "levelId-0": 1,
  "level-0": "1",
  "levelpoints-0": 15,

  "levelId-1": 2,
  "level-1": "2",
  "levelpoints-1": 15,

  "levelId-2": 3,
  "level-2": "3",
  "levelpoints-2": 15,

  "levelId-3": 4,
  "level-3": "4",
  "levelpoints-3": 15,

  "medalId-0": 1,
  "medalName-0": "Bronze",
  "medalsPoint-0": 2020,

  "medalId-1": 2,
  "medalName-1": "Silver",
  "medalsPoint-1": 10,

  "medalId-2": 3,
  "medalName-2": "Gold",
  "medalsPoint-2": 10,

  "medalId-3": 1003,
  "medalName-3": "Platinum",
  "medalsPoint-3": 85
};

console.log(Object.entries(
  Object.keys(info).reduce(
    (output, key) => {
      let group = key.slice(-1);
      if(key.startsWith("level") && !(!((output["level"][group] = output["level"][group] || {})[key] = info[key])){
      key.startsWith("medal")) !== (!(output["medal"][group] = output["medal"][group] || {})[key] = info[key]);
        return output;
    },
    { level: {}, medal: {} }
  )
).reduce((output, item) => (p[item[0]] = Object.values(item[1]),p),{}));

Answer 5

Answer №3

Check out this handy solution for your problem. Hopefully, this will resolve the issue you're facing.

var obj = {
      "levelId-0":1,
      "level-0":"1",
      "levelpoints-0": 15,      
      "levelId-1":2,
      "level-1":"2",
      "levelpoints-1": 15,
      "levelId-2":3,
      "level-2":"3",
      "levelpoints-2": 15,
      "levelId-3":4,
      "level-3":"4",
      "levelpoints-3": 15,
      "medalId-0":1,
      "medalName-0":"Bronze",
      "medalsPoint-0":2020,
      "medalId-1":2,
      "medalName-1":"Silver",
      "medalsPoint-1":10,      
      "medalId-2":3,
      "medalName-2":"Gold",
      "medalsPoint-2":10,
      "medalId-3":1003,
      "medalName-3":"Platinum",
      "medalsPoint-3":85
   }
   
   var yourObj = {
   "level":[],
   "medal":[]
   }
   
   var values =[];
   
   for (key in obj){
          var keyval = key.split('-')  
      
          if(!values[keyval[1]]){
           values[keyval[1]] =[]
          }
         
          values[keyval[1]].push(keyval)
   }
   
  for (i =0;i<values.length;i++){
   var  tempLevelObj = {
            "levelId":"",
            "level":"",
            "points":""
          };
 var tempMedalObj = {
            "medalId":"",
            "medalName":"",
            "points":""
          }
          

  for(j=0;j<values[i].length;j++){

   var joinVal = values[i][j].join('-')
  
   switch(values[i][j][0]){
   case 'levelId' :tempLevelObj.levelId = obj[joinVal] ;break
   case 'level' : tempLevelObj.level = obj[joinVal] ;break
   case 'levelpoints' :tempLevelObj.points = obj[joinVal] ;break
   case 'medalId' :tempMedalObj.medalId = obj[joinVal] ;break
   case 'medalName' :tempMedalObj.medalName = obj[joinVal] ;break
   case 'medalsPoint' :tempMedalObj.points = obj[joinVal] ;break
   }
  
  }
  yourObj.level.push(tempLevelObj)
  yourObj.medal.push(tempMedalObj)
  }
  
  console.log(yourObj)

Answer 6

Check out this handy solution for your problem. Hopefully, this will resolve the issue you're facing.

var obj = {
      "levelId-0":1,
      "level-0":"1",
      "levelpoints-0": 15,      
      "levelId-1":2,
      "level-1":"2",
      "levelpoints-1": 15,
      "levelId-2":3,
      "level-2":"3",
      "levelpoints-2": 15,
      "levelId-3":4,
      "level-3":"4",
      "levelpoints-3": 15,
      "medalId-0":1,
      "medalName-0":"Bronze",
      "medalsPoint-0":2020,
      "medalId-1":2,
      "medalName-1":"Silver",
      "medalsPoint-1":10,      
      "medalId-2":3,
      "medalName-2":"Gold",
      "medalsPoint-2":10,
      "medalId-3":1003,
      "medalName-3":"Platinum",
      "medalsPoint-3":85
   }
   
   var yourObj = {
   "level":[],
   "medal":[]
   }
   
   var values =[];
   
   for (key in obj){
          var keyval = key.split('-')  
      
          if(!values[keyval[1]]){
           values[keyval[1]] =[]
          }
         
          values[keyval[1]].push(keyval)
   }
   
  for (i =0;i<values.length;i++){
   var  tempLevelObj = {
            "levelId":"",
            "level":"",
            "points":""
          };
 var tempMedalObj = {
            "medalId":"",
            "medalName":"",
            "points":""
          }
          

  for(j=0;j<values[i].length;j++){

   var joinVal = values[i][j].join('-')
  
   switch(values[i][j][0]){
   case 'levelId' :tempLevelObj.levelId = obj[joinVal] ;break
   case 'level' : tempLevelObj.level = obj[joinVal] ;break
   case 'levelpoints' :tempLevelObj.points = obj[joinVal] ;break
   case 'medalId' :tempMedalObj.medalId = obj[joinVal] ;break
   case 'medalName' :tempMedalObj.medalName = obj[joinVal] ;break
   case 'medalsPoint' :tempMedalObj.points = obj[joinVal] ;break
   }
  
  }
  yourObj.level.push(tempLevelObj)
  yourObj.medal.push(tempMedalObj)
  }
  
  console.log(yourObj)

Answer 7

Answer №4

give this a shot

function displayJson() {
    function updateObject(properties, keyPath, data) {
        properties.set(keyPath, data);
    }

    var objMap = new Map(),
        jsonResult = {};
    // iteration is needed here based on your specific needs
    updateObject(objMap, 'product.productId', 12345);
    updateObject(objMap, 'product.name', 'Sample Product');
    updateObject(objMap, 'product.price', '$19.99');

    objMap.forEach((data, path) => {
        var keysArr = path.split('.'),
            lastKey = keysArr.pop();
        keysArr.reduce((acc, curr) => acc[curr] = acc[curr] || {}, jsonResult)[lastKey] = data;
    });

    console.log(jsonResult);
    // you can also choose to return the generated JSON object
}

Answer 8

give this a shot

function displayJson() {
    function updateObject(properties, keyPath, data) {
        properties.set(keyPath, data);
    }

    var objMap = new Map(),
        jsonResult = {};
    // iteration is needed here based on your specific needs
    updateObject(objMap, 'product.productId', 12345);
    updateObject(objMap, 'product.name', 'Sample Product');
    updateObject(objMap, 'product.price', '$19.99');

    objMap.forEach((data, path) => {
        var keysArr = path.split('.'),
            lastKey = keysArr.pop();
        keysArr.reduce((acc, curr) => acc[curr] = acc[curr] || {}, jsonResult)[lastKey] = data;
    });

    console.log(jsonResult);
    // you can also choose to return the generated JSON object
}

Answer 9

Answer №5

I believe that the expected outcome provided is inaccurate. In my opinion, the correct expected output would be:

{
  "Grade": [
    {
      "gradeId": 1,
      "grade": "A",
      "score": 95
    },
    {
      "gradeId": 2,
      "grade": "B",
      "score": 85
    },
    {
      "gradeId": 3,
      "grade": "C",
      "score": 75
    }
  ],
  "Award": [
    {
      "awardId": 1,
      "awardName": "Bronze",
      "points": 2020
    },
    {
      "awardId": 2,
      "awardName": "Silver",
      "points": 10
    },
    {
      "awardId": 3,
      "awardName": "Gold",
      "points": 10
    }
  ]
}

Below is the code snippet to generate the desired output:

var abc = {
    "gradeId-0": 1,
    "grade-0": "A",
    "gradescore-0": 95,
    "gradeId-1": 2,
    "grade-1": "B",
    "gradescore-1": 85,
    "gradeId-2": 3,
    "grade-2": "C",
    "gradescore-2": 75,
    "gradeId-3": 4,
    "grade-3": "D",
    "gradescore-3": 65,
    "awardId-0": 1,
    "awardName-0": "Bronze",
    "awardsPoint-0": 2020,
    "awardId-1": 2,
    "awardName-1": "Silver",
    "awardsPoint-1": 10,
    "awardId-2": 3,
    "awardName-2": "Gold",
    "awardsPoint-2": 10,
    "awardId-3": 1003,
    "awardName-3": "Platinum",
    "awardsPoint-3": 85
};
var final = {
    "Grade": [],
    "Award": []
};
let abcKeys = Object.keys(abc);
var lastRowIndex = parseInt(abcKeys[abcKeys.length - 1].split('-')[1]); //3
for (let i = 0; i < lastRowIndex; i++) {
    let gradeObj = {}, awardObj = {};
    gradeObj['gradeId'] = abc['gradeId-' + i];
    gradeObj['grade'] = abc['grade-' + i];
    gradeObj['score'] = abc['gradescore-' + i];
    awardObj['awardId'] = abc['awardId-' + i];
    awardObj['awardName'] = abc['awardName-' + i];
    awardObj['points'] = abc['awardsPoint-' + i];
    final.Grade.push(gradeObj);
    final.Award.push(awardObj);
}
console.log('--final--', final);

Answer 10

I believe that the expected outcome provided is inaccurate. In my opinion, the correct expected output would be:

{
  "Grade": [
    {
      "gradeId": 1,
      "grade": "A",
      "score": 95
    },
    {
      "gradeId": 2,
      "grade": "B",
      "score": 85
    },
    {
      "gradeId": 3,
      "grade": "C",
      "score": 75
    }
  ],
  "Award": [
    {
      "awardId": 1,
      "awardName": "Bronze",
      "points": 2020
    },
    {
      "awardId": 2,
      "awardName": "Silver",
      "points": 10
    },
    {
      "awardId": 3,
      "awardName": "Gold",
      "points": 10
    }
  ]
}

Below is the code snippet to generate the desired output:

var abc = {
    "gradeId-0": 1,
    "grade-0": "A",
    "gradescore-0": 95,
    "gradeId-1": 2,
    "grade-1": "B",
    "gradescore-1": 85,
    "gradeId-2": 3,
    "grade-2": "C",
    "gradescore-2": 75,
    "gradeId-3": 4,
    "grade-3": "D",
    "gradescore-3": 65,
    "awardId-0": 1,
    "awardName-0": "Bronze",
    "awardsPoint-0": 2020,
    "awardId-1": 2,
    "awardName-1": "Silver",
    "awardsPoint-1": 10,
    "awardId-2": 3,
    "awardName-2": "Gold",
    "awardsPoint-2": 10,
    "awardId-3": 1003,
    "awardName-3": "Platinum",
    "awardsPoint-3": 85
};
var final = {
    "Grade": [],
    "Award": []
};
let abcKeys = Object.keys(abc);
var lastRowIndex = parseInt(abcKeys[abcKeys.length - 1].split('-')[1]); //3
for (let i = 0; i < lastRowIndex; i++) {
    let gradeObj = {}, awardObj = {};
    gradeObj['gradeId'] = abc['gradeId-' + i];
    gradeObj['grade'] = abc['grade-' + i];
    gradeObj['score'] = abc['gradescore-' + i];
    awardObj['awardId'] = abc['awardId-' + i];
    awardObj['awardName'] = abc['awardName-' + i];
    awardObj['points'] = abc['awardsPoint-' + i];
    final.Grade.push(gradeObj);
    final.Award.push(awardObj);
}
console.log('--final--', final);

Transform object into distinct entities based on their individual key value pairs

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Similar questions

Configuring routers for my node.js application

remove information within callback

What is the best method for replacing the current page in an Ionic app?

Determining the parameter type of an overloaded callback: A comprehensive guide

Double execution of JavaScript function when Enter key is pressed

Scheduled task running a PHP script which executes a separate PHP script

Decoding JSON information using JQuery/JavaScript

What's preventing my Angular list from appearing?

Unable to properly cancel a post request using abort functionality

I need to extract particular information from a JSON file and include it in another JSON file or variable

The content is spilling over onto the navigation bar

Is it possible to submit a HTML5 form and have it displayed again on the same page?

React Native Issue - Invariant Violation: Invalid Element Type

What is the best way to establish a new JavaScript data type that can be accessed using both key and index?

What is the best way to save a JavaScript object or JSON within an HTML element using the HTML5 data attribute?

Adding a jPlayer on the fly

Javascript encountered an error upon attempting to return from the main function

Creating JavaScript object fields with default values in an AngularJS model: A Step-by-Step Guide

What could be causing this JSON file to be displaying in an unusual manner?

Merging Data with mongoDB