Merge JSON entries with identical names

Question

Merge JSON entries with identical names

Currently, I am delving into the world of javascript and honing my skills in working with JSON.

I have a JSON file that presents a challenge - how can I consolidate entries with the same name under one single entry? Any ideas on how to achieve this?

Original JSON Data

[{
    "name": "1.date.17-Nov-18",
    "size": 1000,
    "imports": ["1.location.HOUSTON", "1.person.JOHN"]
},
{
    "name": "1.date.17-Nov-18",
    "size": 1000,
    "imports": ["1.location.MIAMI", "1.person.BEN", "1.person.JOHN"]
},
{
    "name": "1.date.18-Nov-18",
    "size": 1000,
    "imports": ["1.location.UBER", "1.person.JOHN"]
}
]

Desired Output

[{
    "name": "1.date.17-Nov-18",
    "size": 1000,
    "imports": ["1.location.HOUSTON", "1.person.JOHN", "1.location.MIAMI", "1.person.BEN"]
},
{
    "name": "1.date.18-Nov-18",
    "size": 1000,
    "imports": ["1.location.UBER", "1.person.JOHN"]
}
]

If you have any insights or suggestions on how to tackle this issue, please share them. Thank you!

javascript java arrays json

Answer 1

Answer №1

We utilize an object to maintain a record of the names and then proceed to iterate through the data array by employing the forEach method.

During this process, we validate whether the name of the item has been encountered previously. If it has, we combine their respective imports. Otherwise, we simply add the item to the object.

To ensure no duplicate entries within the imports, we employ a Set which effectively eliminates duplicates, following which we transform it back into an array utilizing the spread operator ....

Finally, we use Object.values to retrieve the consolidated data without the names acting as keys.

const result = {};
const data = [{"name":"1.date.17-Nov-18","size":1000,"imports":["1.location.HOUSTON","1.person.JOHN"]},{"name":"1.date.17-Nov-18","size":1000,"imports":["1.location.MIAMI","1.person.BEN","1.person.JOHN"]},{"name":"1.date.18-Nov-18","size":1000,"imports":["1.location.UBER","1.person.JOHN"]}];

data.forEach(item => {
  if (item.name in result) result[item.name].imports = [...new Set([...item.imports, ...result[item.name].imports])];
  else result[item.name] = item;
});

console.log(Object.values(result));

Answer 2

We utilize an object to maintain a record of the names and then proceed to iterate through the data array by employing the forEach method.

During this process, we validate whether the name of the item has been encountered previously. If it has, we combine their respective imports. Otherwise, we simply add the item to the object.

To ensure no duplicate entries within the imports, we employ a Set which effectively eliminates duplicates, following which we transform it back into an array utilizing the spread operator ....

Finally, we use Object.values to retrieve the consolidated data without the names acting as keys.

const result = {};
const data = [{"name":"1.date.17-Nov-18","size":1000,"imports":["1.location.HOUSTON","1.person.JOHN"]},{"name":"1.date.17-Nov-18","size":1000,"imports":["1.location.MIAMI","1.person.BEN","1.person.JOHN"]},{"name":"1.date.18-Nov-18","size":1000,"imports":["1.location.UBER","1.person.JOHN"]}];

data.forEach(item => {
  if (item.name in result) result[item.name].imports = [...new Set([...item.imports, ...result[item.name].imports])];
  else result[item.name] = item;
});

console.log(Object.values(result));

Answer 3

Answer №2

Transform the array into a Map and remove duplicate imports.

const data = [
  {
    name: '1.date.17-Nov-18',
    size: 1000,
    imports: ['1.location.HOUSTON', '1.person.JOHN'],
  },
  {
    name: '1.date.17-Nov-18',
    size: 1000,
    imports: ['1.location.MIAMI', '1.person.BEN', '1.person.JOHN'],
  },
  {
    name: '1.date.18-Nov-18',
    size: 1000,
    imports: ['1.location.UBER', '1.person.JOHN'],
  },
];

console.log(
  Array.from(data.reduce((m, o) => (
      m.has(o.name)
        ? m.get(o.name).imports.push(...o.imports)
        : m.set(o.name, { ...o }),
      m), new Map()).values(),
    (v) => ({ ...v, imports: [...new Set(v.imports)] }))
);

Answer 4

Transform the array into a Map and remove duplicate imports.

const data = [
  {
    name: '1.date.17-Nov-18',
    size: 1000,
    imports: ['1.location.HOUSTON', '1.person.JOHN'],
  },
  {
    name: '1.date.17-Nov-18',
    size: 1000,
    imports: ['1.location.MIAMI', '1.person.BEN', '1.person.JOHN'],
  },
  {
    name: '1.date.18-Nov-18',
    size: 1000,
    imports: ['1.location.UBER', '1.person.JOHN'],
  },
];

console.log(
  Array.from(data.reduce((m, o) => (
      m.has(o.name)
        ? m.get(o.name).imports.push(...o.imports)
        : m.set(o.name, { ...o }),
      m), new Map()).values(),
    (v) => ({ ...v, imports: [...new Set(v.imports)] }))
);

Answer 5

Answer №3

Here is a solution you can experiment with:

const data = [{"name":"1.date.17-Nov-18","size":1000,"imports":["1.location.HOUSTON","1.person.JOHN"]},{"name":"1.date.17-Nov-18","size":1000,"imports":["1.location.MIAMI","1.person.BEN","1.person.JOHN"]},{"name":"1.date.18-Nov-18","size":1000,"imports":["1.location.UBER","1.person.JOHN"]}];

const result = data.reduce((acc, {name, size, imports}) => {
  acc[name] =  acc[name] || {name: name, size: size, imports: []};
  acc[name].imports = [...new Set([...acc[name].imports, ...imports])];
  
  return acc;
}, {})
console.log(Object.values(result));

.as-console-wrapper{min-height: 100%!important; top: 0}

Answer 6

Here is a solution you can experiment with:

const data = [{"name":"1.date.17-Nov-18","size":1000,"imports":["1.location.HOUSTON","1.person.JOHN"]},{"name":"1.date.17-Nov-18","size":1000,"imports":["1.location.MIAMI","1.person.BEN","1.person.JOHN"]},{"name":"1.date.18-Nov-18","size":1000,"imports":["1.location.UBER","1.person.JOHN"]}];

const result = data.reduce((acc, {name, size, imports}) => {
  acc[name] =  acc[name] || {name: name, size: size, imports: []};
  acc[name].imports = [...new Set([...acc[name].imports, ...imports])];
  
  return acc;
}, {})
console.log(Object.values(result));

.as-console-wrapper{min-height: 100%!important; top: 0}

Answer 7

Answer №4

To tackle this problem, you can utilize the power of Array.prototype.reduce. Since you are just beginning to grasp JavaScript concepts, I will provide a detailed explanation for the solution. Give this code snippet a try:

const data = [{
    "name": "1.date.17-Nov-18",
    "size": 1000,
    "imports": ["1.location.HOUSTON", "1.person.JOHN"]
},
{
    "name": "1.date.17-Nov-18",
    "size": 1000,
    "imports": ["1.location.MIAMI", "1.person.BEN", "1.person.JOHN"]
},
{
    "name": "1.date.18-Nov-18",
    "size": 1000,
    "imports": ["1.location.UBER", "1.person.JOHN"]
}];

let res = data.reduce((acc, curr) => {
  if (acc[curr.name] === undefined) {
    acc[curr.name] = curr;
  } else {
    acc[curr.name].imports.push(...curr.imports);
  }
  return acc;
}, {});

res = Object.values(res);

console.log(res);

.as-console-wrapper{min-height: 100%!important; top: 0}

Answer 8

To tackle this problem, you can utilize the power of Array.prototype.reduce. Since you are just beginning to grasp JavaScript concepts, I will provide a detailed explanation for the solution. Give this code snippet a try:

const data = [{
    "name": "1.date.17-Nov-18",
    "size": 1000,
    "imports": ["1.location.HOUSTON", "1.person.JOHN"]
},
{
    "name": "1.date.17-Nov-18",
    "size": 1000,
    "imports": ["1.location.MIAMI", "1.person.BEN", "1.person.JOHN"]
},
{
    "name": "1.date.18-Nov-18",
    "size": 1000,
    "imports": ["1.location.UBER", "1.person.JOHN"]
}];

let res = data.reduce((acc, curr) => {
  if (acc[curr.name] === undefined) {
    acc[curr.name] = curr;
  } else {
    acc[curr.name].imports.push(...curr.imports);
  }
  return acc;
}, {});

res = Object.values(res);

console.log(res);

.as-console-wrapper{min-height: 100%!important; top: 0}

Merge JSON entries with identical names

Answer №1

Answer №2

Answer №3

Answer №4

Similar questions

What causes the discrepancy in results between Javascript sha1 and PHP5 sha1 when generating hashes for utf-8 strings?

At the initialization of my application, Vue Router effortlessly loads all my dynamically imported components

Unable to retrieve output from function

Tips for retrieving user input and displaying it on an HTML page

Angular: Selecting all checkboxes outside of an ng-repeat loop

Finding a way to access a specific range of bytes within a unique_ptr byte array

Vue: Child component not rendering string prop

Issues with Chrome DevTools script blackboxing functionality not functioning as intended

Having trouble retrieving JSON data from an external URL in AngularJS when making a $http.get call and using the success method?

Making if-else statements easier

What is the process for encoding an image as a Base64 string within a file?

Is it possible to manipulate the GET API response using the Selenium WebDriver or a REST API in order to set the response body as null, for the purpose of testing error handling on the

I am experiencing an issue where my ajax code is unable to display the

Storing a JSON response in an NSPredicate with objective C: A step-by-step guide

Why won't the thread stop in Tomcat?

Use a spy to mock a component method using karma and jasmine

Restricting the number of mat-chips in Angular and preventing the input from being disabled

Unable to invoke modal popup from master page on child page

What is the best method to retrieve an array similar to this from MySQL using PHP?

Sending Emails with AngularJS