Merging JSON Objects with identical numbers of key-value pairs, and combining the main key values

Question

Merging JSON Objects with identical numbers of key-value pairs, and combining the main key values

I have a JSON objects in an old parser program that I wrote years ago.

{"Date":"19/02/16","Narration":"NEFT DR-BARB0PIMPAL-Govt. NE","Chq":{"/Ref":{"No":{"":"N050160130709970"}}},"Value Dt":"19/02/16","Withdrawal Amt":{"":"8,000.00"},"Deposit Amt":{"":""},"Closing Balance":"24,114.95"}

{"Date":"","Narration":"TBANK, MUM-N050160130709970","Chq":{"/Ref":{"No":{"":""}}},"Value Dt":"","Withdrawal Amt":{"":""},"Deposit Amt":{"":""},"Closing Balance":""}

Originally, the above entry was meant to be a single record. However, due to line wrapping, the parser is treating them as separate records.

I attempted to map the objects by converting them into an array, but it resulted in the following JSON object:

{"Date":"19/02/16"}{"Date":""},{"Narration":"NEFT DR-BARB0PIMPAL-Govt. NE"}{"Narration":"TBANK, MUM-N050160130709970"},{"Chq":{"/Ref":{"No":{"":"N050160130709970"}}}}{"Chq":{"/Ref":{"No":{"":""}}}},{"Value Dt":"19/02/16"}{"Value Dt":""},{"Withdrawal Amt":{"":"8,000.00"}}{"Withdrawal Amt":{"":""}},{"Deposit Amt":{"":""}}{"Deposit Amt":{"":""}},{"Closing Balance":"24,114.95"}{"Closing Balance":""}

What I need is to merge/combine this data into a single array or object while keeping the main keys intact and appending values together (with the second object being discarded thereafter).

For instance:

{"Date":"19/02/16","Narration":"NEFT DR-BARB0PIMPAL-Govt.NETBANK","Chq":{"/Ref":{"No":{"":"N050160130709970MUM-N050160130709970"}}},"Value Dt":"19/02/16","Withdrawal Amt":{"":"8,000.00"},"Deposit Amt":{"":""},"Closing Balance":"24,114.95"}

Is there a way to directly merge/combine the source JSON Object or merge the arrays to achieve the desired outcome?

javascript arrays json

Answer 1

Answer №1

In order to merge split objects, it is crucial to have the correct order of these objects. Assuming you have an array of JavaScript objects parsed from JSON format.

Additionally, identifying a record that continues from the previous one can be done by checking for an empty balance field (adjust as necessary).

Below is the code snippet to effectively merge these split objects:

function mergeSplitObjects(arr) {
    return arr.filter( (curr, i) => {
        // Is this object meant to be merged with the previous one?
        if (curr["Closing Balance"] !== "") { // Adjust condition accordingly
            return true; // It's a valid record
        }
        arr[i-1]["Narration"] += curr["Narration"]; // Merge and remove current item
    });
}

// Sample data containing 3 records. The first two should be merged
let arr = [
    {"Date":"19/02/16","Narration":"NEFT DR-BARB0PIMPAL-Govt. NE","Chq":{"/Ref":{"No":{"":"N050160130709970"}}},"Value Dt":"19/02/16","Withdrawal Amt":{"":"8,000.00"},"Deposit Amt":{"":""},"Closing Balance":"24,114.95"},
    {"Date":"","Narration":"TBANK, MUM-N050160130709970","Chq":{"/Ref":{"No":{"":""}}},"Value Dt":"","Withdrawal Amt":{"":""},"Deposit Amt":{"":""},"Closing Balance":""},
    {"Date":"20/02/16","Narration":"ATM NYC 13","Chq":{"/Ref":{"No":{"":"N050160130709971"}}},"Value Dt":"20/02/16","Withdrawal Amt":{"":"1,000.00"},"Deposit Amt":{"":""},"Closing Balance":"23,114.95"},
];
arr = mergeSplitObjects(arr);

console.log(arr);

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

Answer 2

In order to merge split objects, it is crucial to have the correct order of these objects. Assuming you have an array of JavaScript objects parsed from JSON format.

Additionally, identifying a record that continues from the previous one can be done by checking for an empty balance field (adjust as necessary).

Below is the code snippet to effectively merge these split objects:

function mergeSplitObjects(arr) {
    return arr.filter( (curr, i) => {
        // Is this object meant to be merged with the previous one?
        if (curr["Closing Balance"] !== "") { // Adjust condition accordingly
            return true; // It's a valid record
        }
        arr[i-1]["Narration"] += curr["Narration"]; // Merge and remove current item
    });
}

// Sample data containing 3 records. The first two should be merged
let arr = [
    {"Date":"19/02/16","Narration":"NEFT DR-BARB0PIMPAL-Govt. NE","Chq":{"/Ref":{"No":{"":"N050160130709970"}}},"Value Dt":"19/02/16","Withdrawal Amt":{"":"8,000.00"},"Deposit Amt":{"":""},"Closing Balance":"24,114.95"},
    {"Date":"","Narration":"TBANK, MUM-N050160130709970","Chq":{"/Ref":{"No":{"":""}}},"Value Dt":"","Withdrawal Amt":{"":""},"Deposit Amt":{"":""},"Closing Balance":""},
    {"Date":"20/02/16","Narration":"ATM NYC 13","Chq":{"/Ref":{"No":{"":"N050160130709971"}}},"Value Dt":"20/02/16","Withdrawal Amt":{"":"1,000.00"},"Deposit Amt":{"":""},"Closing Balance":"23,114.95"},
];
arr = mergeSplitObjects(arr);

console.log(arr);

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

Answer 3

Answer №2

A function similar to Object.assign could be utilized in this scenario.

In accordance with Trincot's viewpoint, the presence of Closing Balance serves as a signal for merging records.

var splitRegExp = /[a-z],\s*[a-z]/gi;
function deepMergingAssign(obj /*, sourceObjects*/){
    'use strict';
    if (obj == null) throw new TypeError('Cannot convert undefined or null to object');
    var final = Object(obj);
    [].slice.call(arguments, 1).forEach(function(arg){
        if(arg != null) {
            for(var prop in arg) {
                if (typeof arg[prop] === 'object'&&typeof final[prop] === 'object') {
                    // recursively call this function
                    arg[prop] = deepMergingAssign(final[prop],arg[prop]);
                    delete arg[prop]
                }
                else if(Object.prototype.hasOwnProperty.call(arg,prop)) {
                    // append the new values to the existing value.
                    var currentValue = final[prop].split(splitRegExp);
                    var incomingValue = arg[prop].split(splitRegExp);
                    incomingValue.forEach( function(val){
                        if (val! == '' && currentValue.indexOf(val) === -1) currentValue.push(val);
                    });
                    final[prop] = currentValue.join(', ');
                }
            }
        }
    });
    return final;
}

function mergeRecords(records){
    var toMerge = [];
    var mergedData = []
    for (var i=0; i<records.length; i++){
        // Modify this condition as per requirements
        if (records[i]['Closing Balance'] !== '' && toMerge.length>0){
            // Formulate a merged record and reset the toMerge array
            mergedData.push(deepMergingAssign.apply(null, toMerge));
            toMerge = [records[i]];
        }
        else {
            // Merge the current record with the preceding one
            toMerge.push(records[i]);
        }
    }
    // Merge the last set of records stored in the array
    mergedData.push(deepMergingAssign.apply(null, toMerge));

    return mergedData;
}

var allRecords = [
    {"Date":"19/02/16","Narration":"NEFT DR-BARB0PIMPAL-Govt. NE","Chq":{"/Ref":{"No":{"":"N050160130709970"}}},"Value Dt":"19/02/16","Withdrawal Amt":{"":"8,000.00"},"Deposit Amt":{"":""},"Closing Balance":"24,114.95"},
    {"Date":"","Narration":"TBANK, MUM-N050160130709970","Chq":{"/Ref":{"No":{"":""}}},"Value Dt":"","Withdrawal Amt":{"":""},"Deposit Amt":{"":""},"Closing Balance":""},
    {"Date":"21/02/16","Narration":"TBANK","Chq":{"/Ref":{"No":{"":"N050160130709971"}}},"Value Dt":"21/02/16","Withdrawal Amt":{"":""},"Deposit Amt":{"":"2,000.00"},"Closing Balance":"26,114.95"},
    {"Date":"22/02/16","Narration":"TBANK","Chq":{"/Ref":{"No":{"":"N050160130709972"}}},"Value Dt":"22/02/16","Withdrawal Amt":{"":"5,750.00"},"Deposit Amt":{"":"1,000.00"},"Closing Balance":"21,364.95"},
    {"Date":"","Narration":"TBANK, MUM-N050160130709972","Chq":{"/Ref":{"No":{"":""}}},"Value Dt":"","Withdrawal Amt":{"":""},"Deposit Amt":{"":""},"Closing Balance":""}
]

var merged = mergeRecords(allRecords);
/* [
    record 1+2,
    record 3,
    record 4+5
   ] */

Answer 4

A function similar to Object.assign could be utilized in this scenario.

In accordance with Trincot's viewpoint, the presence of Closing Balance serves as a signal for merging records.

var splitRegExp = /[a-z],\s*[a-z]/gi;
function deepMergingAssign(obj /*, sourceObjects*/){
    'use strict';
    if (obj == null) throw new TypeError('Cannot convert undefined or null to object');
    var final = Object(obj);
    [].slice.call(arguments, 1).forEach(function(arg){
        if(arg != null) {
            for(var prop in arg) {
                if (typeof arg[prop] === 'object'&&typeof final[prop] === 'object') {
                    // recursively call this function
                    arg[prop] = deepMergingAssign(final[prop],arg[prop]);
                    delete arg[prop]
                }
                else if(Object.prototype.hasOwnProperty.call(arg,prop)) {
                    // append the new values to the existing value.
                    var currentValue = final[prop].split(splitRegExp);
                    var incomingValue = arg[prop].split(splitRegExp);
                    incomingValue.forEach( function(val){
                        if (val! == '' && currentValue.indexOf(val) === -1) currentValue.push(val);
                    });
                    final[prop] = currentValue.join(', ');
                }
            }
        }
    });
    return final;
}

function mergeRecords(records){
    var toMerge = [];
    var mergedData = []
    for (var i=0; i<records.length; i++){
        // Modify this condition as per requirements
        if (records[i]['Closing Balance'] !== '' && toMerge.length>0){
            // Formulate a merged record and reset the toMerge array
            mergedData.push(deepMergingAssign.apply(null, toMerge));
            toMerge = [records[i]];
        }
        else {
            // Merge the current record with the preceding one
            toMerge.push(records[i]);
        }
    }
    // Merge the last set of records stored in the array
    mergedData.push(deepMergingAssign.apply(null, toMerge));

    return mergedData;
}

var allRecords = [
    {"Date":"19/02/16","Narration":"NEFT DR-BARB0PIMPAL-Govt. NE","Chq":{"/Ref":{"No":{"":"N050160130709970"}}},"Value Dt":"19/02/16","Withdrawal Amt":{"":"8,000.00"},"Deposit Amt":{"":""},"Closing Balance":"24,114.95"},
    {"Date":"","Narration":"TBANK, MUM-N050160130709970","Chq":{"/Ref":{"No":{"":""}}},"Value Dt":"","Withdrawal Amt":{"":""},"Deposit Amt":{"":""},"Closing Balance":""},
    {"Date":"21/02/16","Narration":"TBANK","Chq":{"/Ref":{"No":{"":"N050160130709971"}}},"Value Dt":"21/02/16","Withdrawal Amt":{"":""},"Deposit Amt":{"":"2,000.00"},"Closing Balance":"26,114.95"},
    {"Date":"22/02/16","Narration":"TBANK","Chq":{"/Ref":{"No":{"":"N050160130709972"}}},"Value Dt":"22/02/16","Withdrawal Amt":{"":"5,750.00"},"Deposit Amt":{"":"1,000.00"},"Closing Balance":"21,364.95"},
    {"Date":"","Narration":"TBANK, MUM-N050160130709972","Chq":{"/Ref":{"No":{"":""}}},"Value Dt":"","Withdrawal Amt":{"":""},"Deposit Amt":{"":""},"Closing Balance":""}
]

var merged = mergeRecords(allRecords);
/* [
    record 1+2,
    record 3,
    record 4+5
   ] */

Merging JSON Objects with identical numbers of key-value pairs, and combining the main key values

Answer №1

Answer №2

Similar questions

How to overcome the issue of Bootstrap Modal blocking link functionality?

What is the best way to apply margins to a nested div element in relation to its parent div element using CSS?

Adding unique parameters to a rails form

How to eliminate numerous elements from a bash array using various patterns

Finding the average of a column within a PHP array

Slightly unsure regarding Gzip compression in relation to my web application

What is the best way to prevent Firefox from storing the data of a textarea in the local environment?

Display the button only if the specified condition aligns with the input data

Avoiding Repetition in ListView in Android by Filtering JSON Data with EditText

Reloading a DIV element on the website causes any additional OnClick event handlers to be disabled, along with

Convert the property that starts with XX from XML to JSON

Explanation of if-statements and the ability to read if conditions from another object such as String[] (Dynamic If)

Pandoc fails to display SVG images when converting HTML to DOCX

Can you merge the values between two arrays of objects by counting them and combining them into a single array?

What is the method for individually extracting values from HTML using class li?

What steps can I take to address the problem in iOS 17 where sound is coming from the earpiece instead of the speaker during camera activation?

Tips for maintaining active javascript content within a WebView while navigating to a different page

Steps to create a 3D mesh graph using three 1D arrays in Matlab

Tips on saving content that changes automatically

React function component often uses the "this" keyword in order to