Comparing Objects in an Array to Eliminate Duplicates and Make Updates in Javascript

Question

Comparing Objects in an Array to Eliminate Duplicates and Make Updates in Javascript

I am working with an array of objects that is structured like this:

0: Object
ConsolidatedItem_catalogId: "080808"
ConsolidatedItem_catalogItem: "undefined"
ConsolidatedItem_cost: "0"
ConsolidatedItem_description: "Test Catalog Item"
ConsolidatedItem_imageFile: "27617647008728.jpg"
ConsolidatedItem_itemNumber: "1234"
ConsolidatedItem_quantity: "1"
ConsolidatedItem_source: "CAT"
ConsolidatedItem_status: "02"
ConsolidatedItem_umCode: "EA"

1: Object
ConsolidatedItem_catalogId: ""
ConsolidatedItem_catalogItem: "undefined"
ConsolidatedItem_cost: "0"
ConsolidatedItem_description: "ALARM,SHUTDOWN SYSTEM,AXIOM,XP3, 0-1500 PSIG, HIGH AND LOW PRES Testing"
ConsolidatedItem_imageFile: ""
ConsolidatedItem_itemNumber: "10008"
ConsolidatedItem_quantity: "1"
ConsolidatedItem_source: "INV"
ConsolidatedItem_status: "02"
ConsolidatedItem_umCode: "EA"

I am attempting to update or remove an object if it is duplicated, preferably by updating the values of the existing object. Here is my current code:

var result = $.grep(finalObject, function(e) {
            return e.ConsolidatedItem_itemNumber == o.ConsolidatedItem_itemNumber;
        });
        console.log(result);
        if (result.length == 0) {
            finalObject.push(o);
            shoppingCounter = finalObject.length;
            $('#numberShoppedItems').text(shoppingCounter);
            console.log(finalObject);
        } else if (result.length == 1) {    
            finalObject.filter(function(x){
                result = x;
                console.log(result);
                return x == result.ConsolidatedItem_itemNumber;

            }); 
        } else {
            alert('Multiples Found');
        } 
    }

I have tried various methods to manipulate and update the data in the objects, but have not had success. Ideally, I would like to merge the quantities of objects with the same CatalogItem_itemNumber if their quantities differ. If you have any guidance on how I can approach this problem, it would be greatly appreciated. I have searched for similar questions, but none seem to address this issue directly. If you know of a relevant question with an answer, please feel free to share the link. No Underscore.js solutions, please.

javascript arrays object

Answer 1

Answer №1

Once you have identified the corresponding entry, you can easily modify it using the $.extend method.

        $.extend(result[0], o)

This action will directly update the object within the finalObject array.

Alternatively, if you prefer to utilize a filter, you will have to insert the new object into the array.

        finalObject = finalObject.filter(function(x) {
            return x !== result[0];

        }); 
        finalObject.push(o)

In this scenario, any records that do not match the result will be included in the resulting array stored in finalObject. The next step involves adding the new record to the array.

Answer 2

Once you have identified the corresponding entry, you can easily modify it using the $.extend method.

        $.extend(result[0], o)

This action will directly update the object within the finalObject array.

Alternatively, if you prefer to utilize a filter, you will have to insert the new object into the array.

        finalObject = finalObject.filter(function(x) {
            return x !== result[0];

        }); 
        finalObject.push(o)

In this scenario, any records that do not match the result will be included in the resulting array stored in finalObject. The next step involves adding the new record to the array.

Answer 3

Answer №2

Solution:

1.) Check if the object is not empty.

2.) Utilize .some() on the object to iterate through it.

3.) Verify if the finalObject, now known as e, has a match for the key in the temporary object I create, o.

4.) Update the necessary values and return true;

Note: Initially, I considered removing the object by its index and replacing it with a new object. This can be achieved using .splice() and retrieving the index of the current object within the array.

Below is the updated version:

if (o.ConsolidatedItem_quantity != '') {

    var result = $.grep(finalObject, function(e) {
        return e.ConsolidatedItem_itemNumber == o.ConsolidatedItem_itemNumber;
    });
    if (result.length == 0) {...}
    else {
        finalObject.some(function (e) {
            if(e.ConsolidatedItem_itemNumber == o.ConsolidatedItem_itemNumber){
                var a;
                a = +e.ConsolidatedItem_quantity + +o.ConsolidatedItem_quantity;
                e.ConsolidatedItem_quantity = a.toString();
                document.getElementById(o.ConsolidatedItem_itemNumber).value=a;
                return true;
            };
        });
    }
}

Answer 4

Solution:

1.) Check if the object is not empty.

2.) Utilize .some() on the object to iterate through it.

3.) Verify if the finalObject, now known as e, has a match for the key in the temporary object I create, o.

4.) Update the necessary values and return true;

Note: Initially, I considered removing the object by its index and replacing it with a new object. This can be achieved using .splice() and retrieving the index of the current object within the array.

Below is the updated version:

if (o.ConsolidatedItem_quantity != '') {

    var result = $.grep(finalObject, function(e) {
        return e.ConsolidatedItem_itemNumber == o.ConsolidatedItem_itemNumber;
    });
    if (result.length == 0) {...}
    else {
        finalObject.some(function (e) {
            if(e.ConsolidatedItem_itemNumber == o.ConsolidatedItem_itemNumber){
                var a;
                a = +e.ConsolidatedItem_quantity + +o.ConsolidatedItem_quantity;
                e.ConsolidatedItem_quantity = a.toString();
                document.getElementById(o.ConsolidatedItem_itemNumber).value=a;
                return true;
            };
        });
    }
}

Comparing Objects in an Array to Eliminate Duplicates and Make Updates in Javascript

Answer №1

Answer №2

Similar questions

Upload files via Ajax request is required

Ways to effectively manage multiple asynchronous operations while retrieving emails and attachments using IMAP and JavaScript

Error in Browserify Express App: Unexpected token while parsing the file

What are the steps to transition from @zeit/next-sass deprecation?

Cypress - Mastering negative lookaheads in Regular Expressions

Guide to Deactivating the ENTER Key Functionality in React Material UI Autocomplete Form

The system displayed an 'Error' stating that the variable 'index' is defined in the code but is never actually utilized, resulting in the (no-unused-vars) warning

Why is my console showing a SyntaxError with JSON.parse and an unexpected character?

Angular 2 partial static routing parameters with customizable features

Get a Google Sheets file in CSV format

How can I use conditional 'if' statements to import separate modules in Node.js ES Modules?

dojo combobox with data loaded dynamically from JSON

Generating a constantly evolving 3D model and keeping it current within a web browser

When using PHP, JavaScript, and HTML, you can trigger an image upload immediately after choosing a file using the

What could be the reason that the painting application is not functioning properly on mobile devices?

I'm having trouble with my bootstrap dropdown and I've exhausted all of my options trying to fix it based on my current understanding

Sending a POST request to a Flask server using Stripe and AJAX

What is the best way to display an image along with a description using Firebase and next.js?

The HTML Style for implementing HighChart title text does not work when exporting files

Operating a React application in the background