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

Building a Many-to-Many Relationship in Node.js Using Sequelize.js

Troubles arising while submitting data from AngularJS to Amazon S3

Enhancing an array of objects by incorporating properties using map and promises

What is the best way to manipulate arrays using React hooks?

Implementing Partial Login and Registration Views using AngularJS in conjunction with MVC5 and ASP.NET Identity

Troubleshooting issue with Gulp watch on Node v4.6.0

The console indicates that the state's arrays have been filled, yet I'm unable to retrieve the object[0]

Is it possible to replicate an HTML table using JavaScript without including the headers?

React and Axios: Overcoming CORS Policy to Connect with Java/SpringBoot REST Backend Service

What steps do I need to take to retrieve data in a JSON array based on its

The tablet is having trouble playing the mp3 audio file

Issue with Jest while testing a React component library that has been bundled without the React library

Refresh the div by clicking it

Puppeteer: Interacting with login dialog box fields

Tokenizer method utilizing strings

Discovering the power of Next.js Dynamic Import for handling multiple exportsI hope this

Vue has detected an error during rendering: "TypeError: state.actionInfo.find is not a function"

Using Express.js with synchronous functions can cause the web application to freeze

Using Vue to display a Div inside a TD element of a table does not result in a reactive behavior

What causes Bootstrap to malfunction when the route contains double slashes?