Update the value in a nested object array by cross-referencing it with a second nested object array and inserting the object into the specified

Question

Update the value in a nested object array by cross-referencing it with a second nested object array and inserting the object into the specified

I have a large array of objects with over 10,000 records. Each object contains an array in a specific key value, which needs to be iterated and compared with another array of objects. If there is a match, I want to replace that value with the corresponding object from the comparison array.

Here is an example:

obj1 = [{
  "control_id": "red1234",
  "security_domain": "astrem",
  "control_statement": "testing",
  "descriptio": "test",
  "label": "minimal",
  "technologies": [
    "180"
  ],
  "reference": {
    "string": "string"
  },
  "evaluation": "",
  "category": null
}, {
  "control_id": "red1234",
  "security_domain": "astrem",
  "control_statement": "testing",
  "descriptio": "test",
  "label": "minimal",
  "technologies": [
    "180", "320","3213"
  ],
  "reference": {
    "string": "string"
  },
  "evaluation": "",
  "category": null
}]

obj2 = [
  {
    "id": 94,
    "name": "SUSE Linux Enterprise 12.x"
  },
  {
    "id": 174,
    "name": "Ubuntu 18.x"
  },
  ...
]

In obj1, compare the array of technologies with the array of objects in obj2 using IDs. If there is a match, push the matched object into obj1.

The desired output should look like this:

obj1 = [
  {
    "control_id": "red1234",
    "security_domain": "astrem",
    "control_statement": "testing",
    "descriptio": "test",
    "label": "minimal",
    "technologies": [
      {
        "id": 180,
        "name": "Windows 2019 Server"
      }
    ],
    "reference": {
      "string": "string"
    },
    "evaluation": "",
    "category": null
  },
  {
    "control_id": "red1234",
    "security_domain": "astrem",
    "control_statement": "testing",
    "descriptio": "test",
    "label": "minimal",
    "technologies": [
      {
        "id": 180,
        "name": "Windows 2019 Server"
      },
      {
        "id": 320,
        "name": "Windows 2012 Server"
      },
      {
        "id": 3213,
        "name": "Windows 1999 Server"
      }
    ],
    "reference": {
      "string": "string"
    },
    "evaluation": "",
    "category": null
  }
]

I attempted to achieve this with the following code snippet:

obj1.map(element => element.technologies.forEach((techArrayList, index) => 
     this.operatingSystem.find(o => {
      if (techArrayList == o.id) {
         obj1[element.technologies].technologies[index].replace(o);
      }
     })));

javascript angular typescript rxjs

Answer 1

Answer №1

My approach to this situation would involve the following steps...

/**
 * To simplify and expedite the process, I suggest creating an object with key-value pairs for easy reference:
 * {
 *   1: { id: 1, name: 'Windows Platforms },
 *   2: { id: 2, name: 'Linux Platforms' }
 *   ...
 * }
 */
const technologyMap = obj2.reduce((accumulator, technology) => {
    // For each item in the array, add a new property to the technologyMap using the 'id' as the key
    // This allows direct access to the original object by referencing technologyMap['1']
    accumulator[technology['id']] = { ...technology };
    return accumulator;
}, {});

/**
 * Generate a new list by replacing all technology ids with their corresponding objects
 */
const newBigDataList = obj1.map((dataItem) => {
    const technologies = dataItem.technologies.map((techId) => ({ ...technologyMap[techId] }));
    
    // Return a new object with all properties from dataItem but with updated technologies array
    return { ...dataItem, technologies };
});

/**
 * If the big data list is large and you prefer not to create a new list, you can update the technologies arrays directly
 */
obj1.forEach((dataItem) => {
    const technologies = dataItem.technologies.map((techId) => ({ ...technologyMap[techId] }));

    // Update the existing dataItem with the new array of technology objects
    dataItem.technologies = technologies;
});

Answer 2

My approach to this situation would involve the following steps...

/**
 * To simplify and expedite the process, I suggest creating an object with key-value pairs for easy reference:
 * {
 *   1: { id: 1, name: 'Windows Platforms },
 *   2: { id: 2, name: 'Linux Platforms' }
 *   ...
 * }
 */
const technologyMap = obj2.reduce((accumulator, technology) => {
    // For each item in the array, add a new property to the technologyMap using the 'id' as the key
    // This allows direct access to the original object by referencing technologyMap['1']
    accumulator[technology['id']] = { ...technology };
    return accumulator;
}, {});

/**
 * Generate a new list by replacing all technology ids with their corresponding objects
 */
const newBigDataList = obj1.map((dataItem) => {
    const technologies = dataItem.technologies.map((techId) => ({ ...technologyMap[techId] }));
    
    // Return a new object with all properties from dataItem but with updated technologies array
    return { ...dataItem, technologies };
});

/**
 * If the big data list is large and you prefer not to create a new list, you can update the technologies arrays directly
 */
obj1.forEach((dataItem) => {
    const technologies = dataItem.technologies.map((techId) => ({ ...technologyMap[techId] }));

    // Update the existing dataItem with the new array of technology objects
    dataItem.technologies = technologies;
});

Answer 3

Answer №2

Start by mapping the value from obj1 and searching for it in obj2

obj1.forEach((o) => {
      let newArr = o.key.map((k) => {
        const foundObject = obj2.find((ele) => {
          return ele.id == k;
        });
        return foundObject;
      });
      o.key = newArr;
    });

Answer 4

Start by mapping the value from obj1 and searching for it in obj2

obj1.forEach((o) => {
      let newArr = o.key.map((k) => {
        const foundObject = obj2.find((ele) => {
          return ele.id == k;
        });
        return foundObject;
      });
      o.key = newArr;
    });

Update the value in a nested object array by cross-referencing it with a second nested object array and inserting the object into the specified

Answer №1

Answer №2

Similar questions

Using the TIMESTAMP data type in PostgreSQL and getting the most out of it

Assign a value to the input field based on changes made in another input field

Issue with inline Javascript not functioning correctly when partial is rerendered in Ruby on Rails version 3.1

Developing a custom CSS for React using clamp and focus attributes

Is there a way to retrieve the form name within my directive?

Iterate through the Ionic3/Angular4 object using a loop

TSConfig - Automatically Generates a ".js" File for Every ".ts" File

Why don't I need to include an onload event to execute the setInterval() method within the script tag?

Storing the order of jQuery UI Sortable in the WordPress Admin Panel

Why won't my picture track the movement of the cursor?

Experience the simplicity of running basic Javascript Scratch code within IntelliJ IDEA Ultimate

When the progress bar is clicked, the background color changes and then changes back again

Utilizing an Array of objects in conjunction with $.when

Having trouble implementing the page object model with cucumber.js: bug detected!

Tips for implementing two functions to run within the onClick event handler in React

Javascript datatables do not allow for setting a default column sort

Create a custom VueJS component by utilizing an npm package

Express Validator: The Art of Isolating Validation Logic

How to use JQuery to parse an external JSON file with array elements in Javascript

Keep the sub-menu in a kendo context menu from closing until the user either hovers over another menu item or clicks outside of the current item