How to generate a nested array of objects from an source json object

Question

Using the value from an array of object I'm trying to generate an another array of objects with a different structure than that of the original array.

In the following example arrays you can see that from the key:value pairs the key is changing between the Source array and Result array but the values are same. I had tried some code but not worthwhile to share. What logic or method can be used in this case to generate the object structure mentioned below

Source array

[
  {
    "node": {
      "Charecter": "Hulk",
      "Publisher": "Marvel",
      "Movie": "Avengers"
    }
  },
  {
    "node": {
      "Charecter": "Wolverine",
      "Publisher": "Marvel",
      "Movie": "X-Men"
    }
  },
  {
    "node": {
      "Charecter": "Superman",
      "Publisher": "DC",
      "Movie": "Man of steel"
    }
  }
]

Result array

[
  {
    "Franchise": "Marvel",
    "Data": [
      {
        "Lead": "Hulk",
        "In": "Avengers"
      },
      {
        "Lead": "Wolverine",
        "In": "X-Men"
      }
    ]
  },
  {
    "Franchise": "DC",
    "Data": [
      {
        "Lead": "Superman",
        "In": "Man of steer"
      }
    ]
  },
]

Answer 1

Using .reduce() and .find() combination you can achieve the goal.

Try the following:

const data = [{ "node": { "Charecter": "Hulk", "Publisher": "Marvel", "Movie": "Avengers" } }, { "node": { "Charecter": "Wolverine","Publisher": "Marvel","Movie": "X-Men" } }, {"node": { "Charecter": "Superman", "Publisher": "DC","Movie": "Man of steel" } }];

const result = data.reduce((a, c) => {
  const found = a.find(e => e.Franchise === c.node.Publisher);
  
  if (found) found.Data.push({ Lead: c.node.Charecter, In: c.node.Movie });
  else a.push({ Franchise: c.node.Publisher, Data: [{ Lead: c.node.Charecter, In: c.node.Movie }] });

  return a;
}, []);

console.log(result)

I hope this helps!