parsing and building a sophisticated JSON object

Question

parsing and building a sophisticated JSON object

i have a complex array structure as shown below,

array=[ 
  { 'mm': '1', exp: 'exp1' },
  { 'mm': '2', exp: 'exp2' },
  { 'mm': [ '1', '3', '7' ], exp: 'exp3' },
  { 'mm': [ '1', '2', '4', '6' ], exp: 'exp4' },
  { 'mm': [ '1', '3', '2' ], exp: 'exp5' },
  { 'mm': [ '8', '2', '9' ], exp: 'exp6' },
  { 'mm': [ '4', '7', '1', '2' ], exp: 'exp7' },
  { 'mm': [ '5', '6', '2', '4', '3', '8', '1' ], exp: 'exp8' } 
]

i am looking for a way to restructure this array by flipping keys with values and vice versa. The expected output should look like this:

    [ 
      { 'mm': '1', exp: ['exp1','exp3','exp4',','exp5','exp7','exp8'] },
      { 'mm': '2', exp: ['exp2','exp4','exp5','exp6','exp7','exp8'] },
      { 'mm': '3', exp: ['exp3','exp5','exp8'] },
      { 'mm':'4', exp:['exp4','exp7','exp8'] },
      { 'mm':'5', exp:['exp8'] },
      { 'mm':'6', exp:['exp4','exp8'] },
      { 'mm':'7', exp: ['exp3','exp7'] },
      { 'mm':'8', exp: ['exp6','exp8] },
      { 'mm':'9', exp: ['exp6'] }
]

i would appreciate any efficient solutions or suggestions while i continue working on solving this problem myself.

javascript arrays json parsing nested

Answer 1

Answer №1

This implementation utilizes a pair of nested loops along with an object for storing references to the correct element in the final array.

var data = [{ 'mm': '1', exp: 'exp1' }, { 'mm': '2', exp: 'exp2' }, { 'mm': ['1', '3', '7'], exp: 'exp3' }, { 'mm': ['1', '2', '4', '6'], exp: 'exp4' }, { 'mm': ['1', '3', '2'], exp: 'exp5' }, { 'mm': ['8', '2', '9'], exp: 'exp6' }, { 'mm': ['4', '7', '1', '2'], exp: 'exp7' }, { 'mm': ['5', '6', '2', '4', '3', '8', '1'], exp: 'exp8' }],
    pivot = function (data) {
        var result = [], refObj = {};
        data.forEach(function (item) {
            [].concat(item.mm).forEach(function (value) {
                if (!refObj[value]) {
                    refObj[value] = { mm: value, exp: [] };
                    result.push(refObj[value]);
                }
                refObj[value].exp.push(item.exp);
            });
        });
        return result;
    }(data);

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

Answer 2

This implementation utilizes a pair of nested loops along with an object for storing references to the correct element in the final array.

var data = [{ 'mm': '1', exp: 'exp1' }, { 'mm': '2', exp: 'exp2' }, { 'mm': ['1', '3', '7'], exp: 'exp3' }, { 'mm': ['1', '2', '4', '6'], exp: 'exp4' }, { 'mm': ['1', '3', '2'], exp: 'exp5' }, { 'mm': ['8', '2', '9'], exp: 'exp6' }, { 'mm': ['4', '7', '1', '2'], exp: 'exp7' }, { 'mm': ['5', '6', '2', '4', '3', '8', '1'], exp: 'exp8' }],
    pivot = function (data) {
        var result = [], refObj = {};
        data.forEach(function (item) {
            [].concat(item.mm).forEach(function (value) {
                if (!refObj[value]) {
                    refObj[value] = { mm: value, exp: [] };
                    result.push(refObj[value]);
                }
                refObj[value].exp.push(item.exp);
            });
        });
        return result;
    }(data);

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

Answer 3

Answer №2

I'm not entirely clear on what you mean by 'cannot hardcode any values', but I wanted to provide an illustrative solution nonetheless. This code snippet is not optimized for performance, but rather aims to showcase a general approach.

var data =[ 
  { 'mm': '1', exp: 'exp1' },
  { 'mm': '2', exp: 'exp2' },
  { 'mm': [ '1', '3', '7' ], exp: 'exp3' },
  { 'mm': [ '1', '2', '4', '6' ], exp: 'exp4' },
  { 'mm': [ '1', '3', '2' ], exp: 'exp5' },
  { 'mm': [ '8', '2', '9' ], exp: 'exp6' },
  { 'mm': [ '4', '7', '1', '2' ], exp: 'exp7' },
  { 'mm': [ '5', '6', '2', '4', '3', '8', '1' ], exp: 'exp8' } 
];

var tempData = {};
var newData = [];

data.forEach(function(dataPoint) {
    var arrPoint = {
        mm: [].concat(dataPoint.mm),
        exp: [].concat(dataPoint.exp)
    };

    arrPoint.mm.forEach(function (code) {
        if (!tempData[code]) {
            tempData[code] = {
                mm: code,
                exp: []
            }
        }

        var vals = tempData[code].exp;

        arrPoint.exp.forEach(function(val) {
            if (vals.indexOf(val) === -1) {
                vals.push(val);
            }
        });

    });
});


for (var propName in tempData) {
    if (tempData.hasOwnProperty(propName)) {
        newData.push(tempData[propName]);
    }
}

document.write(JSON.stringify(newData));

Next time, it's probably best if you try tackling the problem on your own first before seeking help. This way, your question can be more specific and targeted.

Answer 4

I'm not entirely clear on what you mean by 'cannot hardcode any values', but I wanted to provide an illustrative solution nonetheless. This code snippet is not optimized for performance, but rather aims to showcase a general approach.

var data =[ 
  { 'mm': '1', exp: 'exp1' },
  { 'mm': '2', exp: 'exp2' },
  { 'mm': [ '1', '3', '7' ], exp: 'exp3' },
  { 'mm': [ '1', '2', '4', '6' ], exp: 'exp4' },
  { 'mm': [ '1', '3', '2' ], exp: 'exp5' },
  { 'mm': [ '8', '2', '9' ], exp: 'exp6' },
  { 'mm': [ '4', '7', '1', '2' ], exp: 'exp7' },
  { 'mm': [ '5', '6', '2', '4', '3', '8', '1' ], exp: 'exp8' } 
];

var tempData = {};
var newData = [];

data.forEach(function(dataPoint) {
    var arrPoint = {
        mm: [].concat(dataPoint.mm),
        exp: [].concat(dataPoint.exp)
    };

    arrPoint.mm.forEach(function (code) {
        if (!tempData[code]) {
            tempData[code] = {
                mm: code,
                exp: []
            }
        }

        var vals = tempData[code].exp;

        arrPoint.exp.forEach(function(val) {
            if (vals.indexOf(val) === -1) {
                vals.push(val);
            }
        });

    });
});


for (var propName in tempData) {
    if (tempData.hasOwnProperty(propName)) {
        newData.push(tempData[propName]);
    }
}

document.write(JSON.stringify(newData));

Next time, it's probably best if you try tackling the problem on your own first before seeking help. This way, your question can be more specific and targeted.

parsing and building a sophisticated JSON object

Answer №1

Answer №2

Similar questions

Javascript build a list of location classifications

Vuejs: Limiting the number of items in an li tag to 5

Creating space between flex items in Slick Carousel with Vue

The Django CSRF token is inaccessible for retrieval

What is the process of including a pre-existing product as nested attributes in Rails invoices?

Issue with the recursive function in javascript for object modification

When using Angular2, I have found that I am unable to extract the body data from JSONP responses. However, I have discovered that this issue

What is the optimal value for the variable x in this scenario?

search through an object to find specific data

The ajaxForm function is failing to execute properly and is not providing any error messages

Using jQuery to retrieve the id with [id^=''] when making an AJAX request, then populating and generating a table based on the retrieved data

Restful Spinner

What could be the reason for getElementsByClassName failing to work on dynamic HTML elements?

Silly problem arising from the animate feature in jQuery

Restrict access to table records by specifying an array of row identifiers

Explore the titles provided by Wikipedia

What could be the reason for the discrepancy between the values displayed in the two alerts? What is causing this difference in

The use of DefaultAnnotationHandlerMapping in the dispatcher.xml file is no longer recommended

Having trouble getting the Keycloak provider to work with Next-Auth?

Button click functionality for updating in Classic ASP is functioning correctly exclusively in Internet Explorer and not in other web browsers