Organize an array of JSON objects based on a specific key and eliminate any duplicated entries

Question

Organize an array of JSON objects based on a specific key and eliminate any duplicated entries

I am grappling with the challenge of grouping an array of JSON objects by the id_commande attribute and eliminating any duplicates. I am finding it quite perplexing to figure out a solution to this issue without relying on a library like lodash. Ideally, I would like to tackle this problem using plain JavaScript.

let commandList = [
                 {
                    id_commande: 18,
                    date: "2020-12-07",
                    etat: "en traitement",
                    nom: "Tom Kha Gai",
                    prix_total: 16.68,
                    quantite: 1,
                },
                {
                    id_commande: 18,
                    date: "2020-12-07",
                    etat: "en traitement",
                    nom: "Tom Yum Talai",
                    prix_total: 16.68,
                    quantite: 1,
                },
                {
                    id_commande: 19,
                    date: "2020-12-07",
                    etat: "en traitement",
                    nom: "Tom Yum Gai",
                    prix_total: 16.1,
                    quantite: 1,
                },
                {
                    id_commande: 19,
                    date: "2020-12-07",
                    etat: "en traitement",
                    nom: "Tom Yum Tai",
                    prix_total: 16.1,
                    quantite: 1,
                }
            ];

The desired output is :

let combined = [{
                        id_commande: 18,
                        date: "2020-12-07",
                        etat: "en traitement",
                        plats: [{
                                nom: "Tom Kha Gai",
                                quantite: 1
                            },
                            {
                                nom: "Tom Yum Talai",
                                quantite: 1
                            }
                        ],
                        prix_total: 16.68
                    },
                    {
                        id_commande: 19,
                        date: "2020-12-07",
                        etat: "en traitement",
                        plats: [{
                                nom: "Tom Yum Gai",
                                quantite: 1
                            },
                            {
                                nom: "Tom Yum Tai",
                                quantite: 1
                            }
                        ],
                        prix_total: 16.1
                    },
                ]

javascript arrays json

Answer 1

Answer №1

If you want to effectively manage this data, consider using the reduce method.

let orderList = [
    {
        order_id: 18,
        date: "2020-12-07",
        status: "processing",
        name: "Tom Kha Gai",
        total_price: 16.68,
        quantity: 1,
    },
    {
        order_id: 18,
        date: "2020-12-07",
        status: "processing",
        name: "Tom Yum Talai",
        total_price: 16.68,
        quantity: 1,
    },
    {
        order_id: 19,
        date: "2020-12-07",
        status: "processing",
        name: "Tom Yum Gai",
        total_price: 16.1,
        quantity: 1,
    },
    {
        order_id: 19,
        date: "2020-12-07",
        status: "processing",
        name: "Tom Yum Tai",
        total_price: 16.1,
        quantity: 1,
    }
];

const result = orderList.reduce((res, current) => {
    const existingOrder = res.find(e => e.order_id === current.order_id);
    if (existingOrder) {
        existingOrder.items = [...existingOrder.items, { name: current.name, quantity: current.quantity }]
        return res
    } else {
        return [...res, {
            order_id: current.order_id,
            date: current.date,
            status: current.status,
            items: [{
                name: current.name,
                quantity: current.quantity
            }],
            total_price: current.total_price
        }]
    }
}, [])

console.log(result)

Answer 2

If you want to effectively manage this data, consider using the reduce method.

let orderList = [
    {
        order_id: 18,
        date: "2020-12-07",
        status: "processing",
        name: "Tom Kha Gai",
        total_price: 16.68,
        quantity: 1,
    },
    {
        order_id: 18,
        date: "2020-12-07",
        status: "processing",
        name: "Tom Yum Talai",
        total_price: 16.68,
        quantity: 1,
    },
    {
        order_id: 19,
        date: "2020-12-07",
        status: "processing",
        name: "Tom Yum Gai",
        total_price: 16.1,
        quantity: 1,
    },
    {
        order_id: 19,
        date: "2020-12-07",
        status: "processing",
        name: "Tom Yum Tai",
        total_price: 16.1,
        quantity: 1,
    }
];

const result = orderList.reduce((res, current) => {
    const existingOrder = res.find(e => e.order_id === current.order_id);
    if (existingOrder) {
        existingOrder.items = [...existingOrder.items, { name: current.name, quantity: current.quantity }]
        return res
    } else {
        return [...res, {
            order_id: current.order_id,
            date: current.date,
            status: current.status,
            items: [{
                name: current.name,
                quantity: current.quantity
            }],
            total_price: current.total_price
        }]
    }
}, [])

console.log(result)

Answer 3

Answer №2

give this a shot:

var orderList = [
                 {
                    order_id: 18,
                    date: "2020-12-07",
                    status: "processing",
                    item: "Tom Kha Gai",
                    total_price: 16.68,
                    quantity: 1,
                },
                {
                    order_id: 18,
                    date: "2020-12-07",
                    status: "processing",
                    item: "Tom Yum Talai",
                    total_price: 16.68,
                    quantity: 1,
                },
                {
                    order_id: 19,
                    date: "2020-12-07",
                    status: "processing",
                    item: "Tom Yum Gai",
                    total_price: 16.1,
                    quantity: 1,
                },
                {
                    order_id: 19,
                    date: "2020-12-07",
                    status: "processing",
                    item: "Tom Yum Tai",
                    total_price: 16.1,
                    quantity: 1,
                }
            ];
        groupedOrders = function (orderList) {
        var result = [];
        orderList.forEach(function (a) {
            var key = a.order_id + '|' + a.date+ '|' + a.status;
            if (!this[key]) {
                this[key] = { order_id: a.order_id, date: a.date, status: a.status, items: [] };
                result.push(this[key]);
            }
            this[key].items.push({name : a.item, quantity : a.quantity});

        }, {});
        return result;
    }(orderList);    
           
           document.write('<pre>' + JSON.stringify(groupedOrders, 0, 4) + '</pre>');

Answer 4

give this a shot:

var orderList = [
                 {
                    order_id: 18,
                    date: "2020-12-07",
                    status: "processing",
                    item: "Tom Kha Gai",
                    total_price: 16.68,
                    quantity: 1,
                },
                {
                    order_id: 18,
                    date: "2020-12-07",
                    status: "processing",
                    item: "Tom Yum Talai",
                    total_price: 16.68,
                    quantity: 1,
                },
                {
                    order_id: 19,
                    date: "2020-12-07",
                    status: "processing",
                    item: "Tom Yum Gai",
                    total_price: 16.1,
                    quantity: 1,
                },
                {
                    order_id: 19,
                    date: "2020-12-07",
                    status: "processing",
                    item: "Tom Yum Tai",
                    total_price: 16.1,
                    quantity: 1,
                }
            ];
        groupedOrders = function (orderList) {
        var result = [];
        orderList.forEach(function (a) {
            var key = a.order_id + '|' + a.date+ '|' + a.status;
            if (!this[key]) {
                this[key] = { order_id: a.order_id, date: a.date, status: a.status, items: [] };
                result.push(this[key]);
            }
            this[key].items.push({name : a.item, quantity : a.quantity});

        }, {});
        return result;
    }(orderList);    
           
           document.write('<pre>' + JSON.stringify(groupedOrders, 0, 4) + '</pre>');

Organize an array of JSON objects based on a specific key and eliminate any duplicated entries

Answer №1

Answer №2

Similar questions

Mastering the art of grouping by a key and generating sub-objects from a plain array of key-value pairs in JavaScript ES5 without relying on third-party libraries

Encountering a npm script error while running on a Windows operating

Securing Codeigniter with CSRF protection while using datatables and an AJAX URL

Creating a custom jQuery selector

Obtain the range of values for a match from an array using Vue.js

Adjust the text color based on the background image or color

What is the proper way to add a string to a TypeScript array?

What is the quickest and most effortless method for accessing the API using developer tools?

ReactJS integration issue with Material Design Lite (import/require problem)

Change the color of this element and input field background

Why are JS & jQuery's inArray() and indexOf() functions not functioning correctly when indexes are strings?

Determine the Height of the Container once the Font File has Finished Loading

JavaScript code to shift a box beyond the boundaries of a grid

jQuery's visibility check function is not functioning properly

Error: Certain Prisma model mappings are not being generated

Utilize the scrollIntoView method within a jQuery function

What is the process for changing the output paper size to A4 in React Native (expo android)?

What is the process of emphasizing a WebElement in WebdriverIO?

Determining the total number of combinations possible from a collection of five arrays containing items

Potential Scope Problem in Angular JS Controller