Sort items into two arrays based on a common value

Question

Sort items into two arrays based on a common value

I'm struggling to group items from one array based on a value from another array, but I can't seem to figure out the right approach.

In my orders array, each object has a key-value pair like id: 999324. Now, in another array for products, there are multiple objects with different or matching ids like orderlineId: 999324. My goal is to group together those objects with matching IDs.

Order array

[{
    "agreement": null,
    "channel": null,
    "collection": "Colect 2019",
    "comment": "Comment here",
    "customerNo": "140159",
    "customerOrderReference": "CustomerOReference",
    "customerPriceGroup": "1,7",
    "erpOrderReference": "1337ORDERREFERENCE",
    "externalUrl": null,
    "id": 99945333,
},
{
    ...
]

Products array

[{
        "crossReference": null,
        "currency": "EU",
        "deliverySubBlock": null,
        "eanCode": "8717945155406",
        "grossLineAmount": 99.99,
        "grossWholesalePrice": 99.99,
        "id": 1156718740,
        "orderlineId": 99945334,
},
{
    ...
}]

The desired output would be an array of orders with nested arrays containing all products that match the orders.id and products.orderlineId.

[{
{
    "agreement": null,
    "channel": null,
    "collection": "Colect 2019",
    ...
    "id": 99945334,
    "orderLines" [
     {
        ...
     },
     ...
},
{
    ...
}]

I've attempted various methods, such as:


for(let i=0; i<orders.length; i++) {
  merged.push({
   ...products[i], 
   ...(orders.find((itmInner) => itmInner.id === products[i].orderlineId))}
  );
}

But it's not yielding the correct result. Any guidance on what I may be doing wrong would be greatly appreciated.

I hope I've explained my issue clearly since this is my first post on Stack Overflow.

javascript arrays merge grouping

Answer 1

Answer №1

This code snippet utilizes the filter method to filter for matching ids and mutates the objects in the orders array.
To optimize performance for large data sets, it is recommended to use an object map lookup table to track ids. This way, you can avoid iterating through the entire products array for every order, reducing complexity from O(N^2) to O(N).
(You would create an object map based on orders' ids, allowing you to iterate through the orders array only once and then through the products array only once)

orders.forEach(order=>
  order.productLines = products.filter(p => p.orderlineId === order.id)
)

console.log(orders)

<script>
orders = [{
    "agreement": null,
    "channel": null,
    "collection": "Colect 2019",
    "comment": "Comment here",
    "customerNo": "140159",
    "customerOrderReference": "CustomerOReference",
    "customerPriceGroup": "1,7",
    "erpOrderReference": "1337ORDERREFERENCE",
    "externalUrl": null,
    "id": 99945333,
},
{
    "agreement": null,
    "channel": null,
    "collection": "Colect 2019",
    "comment": "Comment here",
    "customerNo": "140159",
    "customerOrderReference": "CustomerOReference",
    "customerPriceGroup": "1,7",
    "erpOrderReference": "1337ORDERREFERENCE",
    "externalUrl": null,
    "id": 99945334,
}]

products = [{
        "crossReference": null,
        "currency": "EU",
        "deliverySubBlock": null,
        "eanCode": "8717945155406",
        "grossLineAmount": 99.99,
        "grossWholesalePrice": 99.99,
        "id": 1156718740,
        "orderlineId": 99945334,
},
{
        "crossReference": null,
        "currency": "EU",
        "deliverySubBlock": null,
        "eanCode": "8717945155406",
        "grossLineAmount": 99.99,
        "grossWholesalePrice": 99.99,
        "id": 1156718740,
        "orderlineId": 99945334,
},
{
        "crossReference": null,
        "currency": "EU",
        "deliverySubBlock": null,
        "eanCode": "8717945155406",
        "grossLineAmount": 99.99,
        "grossWholesalePrice": 99.99,
        "id": 1156718740,
        "orderlineId": 99945334
}]
</script>

Answer 2

This code snippet utilizes the filter method to filter for matching ids and mutates the objects in the orders array.
To optimize performance for large data sets, it is recommended to use an object map lookup table to track ids. This way, you can avoid iterating through the entire products array for every order, reducing complexity from O(N^2) to O(N).
(You would create an object map based on orders' ids, allowing you to iterate through the orders array only once and then through the products array only once)

orders.forEach(order=>
  order.productLines = products.filter(p => p.orderlineId === order.id)
)

console.log(orders)

<script>
orders = [{
    "agreement": null,
    "channel": null,
    "collection": "Colect 2019",
    "comment": "Comment here",
    "customerNo": "140159",
    "customerOrderReference": "CustomerOReference",
    "customerPriceGroup": "1,7",
    "erpOrderReference": "1337ORDERREFERENCE",
    "externalUrl": null,
    "id": 99945333,
},
{
    "agreement": null,
    "channel": null,
    "collection": "Colect 2019",
    "comment": "Comment here",
    "customerNo": "140159",
    "customerOrderReference": "CustomerOReference",
    "customerPriceGroup": "1,7",
    "erpOrderReference": "1337ORDERREFERENCE",
    "externalUrl": null,
    "id": 99945334,
}]

products = [{
        "crossReference": null,
        "currency": "EU",
        "deliverySubBlock": null,
        "eanCode": "8717945155406",
        "grossLineAmount": 99.99,
        "grossWholesalePrice": 99.99,
        "id": 1156718740,
        "orderlineId": 99945334,
},
{
        "crossReference": null,
        "currency": "EU",
        "deliverySubBlock": null,
        "eanCode": "8717945155406",
        "grossLineAmount": 99.99,
        "grossWholesalePrice": 99.99,
        "id": 1156718740,
        "orderlineId": 99945334,
},
{
        "crossReference": null,
        "currency": "EU",
        "deliverySubBlock": null,
        "eanCode": "8717945155406",
        "grossLineAmount": 99.99,
        "grossWholesalePrice": 99.99,
        "id": 1156718740,
        "orderlineId": 99945334
}]
</script>

Answer 3

Answer №2

To achieve what you're looking for, start by including the order in the merged array as the order will always be one of the products, and then add the orderlineId of the product that matches the id of the order.

Since the orders array contains all the orders and the products array may have more elements than orders, the loop should iterate through the length of the products array. This way, the merged array will group all elements with the same value together.

Does this align with your objective?

products.forEach(product => {
    let order = orders.find(order => product.orderlineId === order.id)
    merged = [...merged, { ...product, ...order } ]
})

Let's consider an example with orders array:

let orders = [{ id: 23432}, {id: 11111}, {id: 56789}];
let products = [{orderlineId: 83}, {orderlineId: 11111}, {orderlineId: 56789}, {orderlineId: 23432}]
let merged = []

// after running the above code snippet, the merged array would look like this...

merged = [
{orderlineId: 83}, 
{orderlineId: 11111, id: 11111},
{orderlineId: 56789, id: 56789},
{orderlineId: 23432, id: 23432}
]

Does this result match your expectations? If so, interchange products with orders and orders with the products array in your loop.

Answer 4

To achieve what you're looking for, start by including the order in the merged array as the order will always be one of the products, and then add the orderlineId of the product that matches the id of the order.

Since the orders array contains all the orders and the products array may have more elements than orders, the loop should iterate through the length of the products array. This way, the merged array will group all elements with the same value together.

Does this align with your objective?

products.forEach(product => {
    let order = orders.find(order => product.orderlineId === order.id)
    merged = [...merged, { ...product, ...order } ]
})

Let's consider an example with orders array:

let orders = [{ id: 23432}, {id: 11111}, {id: 56789}];
let products = [{orderlineId: 83}, {orderlineId: 11111}, {orderlineId: 56789}, {orderlineId: 23432}]
let merged = []

// after running the above code snippet, the merged array would look like this...

merged = [
{orderlineId: 83}, 
{orderlineId: 11111, id: 11111},
{orderlineId: 56789, id: 56789},
{orderlineId: 23432, id: 23432}
]

Does this result match your expectations? If so, interchange products with orders and orders with the products array in your loop.

Sort items into two arrays based on a common value

Answer №1

Answer №2

Similar questions

How to interact with a C# List using JavaScript

Attempting to switch between classes with the click of a button

Create PDF files on-the-fly using the html-pdf module

The issue I am facing is that the Vuetify v-data-table is failing to display the data

Visual Matrix and Directional Controls

How come I lose a day when attempting to convert a date to an ISO string in JavaScript?

Issue with displaying nested React Elements from Component

Icons positioned absolutely outside of components will not be responsive to user interactions

Developing a unique bundle with tailored elements

Why is the code able to execute following the setState hook without any listener declared in the useEffect hook?

Passing default props to a component in React that includes a function as one of the

Is it possible to showcase a dropdown list within a constantly changing table?

Tips for utilizing state and city dropdown menus in JavaScript multiple times without interfering with other dropdowns

"GM_openInTab in Userscript (Scriptish) not working properly, returning null value

Preventing Express.JS HTTP requests from being blocked by npm cron

Is there a problem with the alignment of

How can I move a TableItem from one material UI component to another using drag-and-drop?

Get ready for 10 AM with the RxJS timer function

Is it possible to hide a fixed header on scroll in a mobile device?

Retrieve and dynamically load an entire webpage using AJAX