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

Guide to encoding an array of objects into a URI-friendly query string using TypeScript

The property in the object cannot be assigned because it is read-only: [object Object]

Modify the css with JQUERY when there are no rows inside the tbody section

Ways to reset the selected option when the user chooses a different option using either Jquery or Vanilla JavaScript

What is the best method for loading multiple HTML files into a Div container?

When updating the data in a datatables.net table within Angular 7, the previous data from the initial table load is retained

Finding the occurrences of elements in an array using JavaScript

Display tab content in Vue.js upon clicking

The absence of a defined window - react-draft-wysiwyg integration with Next.js (SSR) is causing issues

The basic function is ineffective when used within an if-condition

npm unable to locate a JavaScript file

Searching for a specific data point within the latest entry of a JSON file using Javascript

Is there a way to effectively sort through Firebase database entries using Angular based on checkbox selection?

A step-by-step guide on transferring data from a dynamic user interface to a server using React Native

Utilizing precise data types for return values in React hooks with Typescript based on argument types

What could be causing the triggering of two AJAX requests in the given JavaScript code?

A possible invocation of a function using a JavaScript "class"

Switching Tabs When a Button is Clicked

Guide to rendering a div class conditionally in a Razor page depending on a variable?

Is it possible to delete browsing history in Express using node.js?