Merge array of objects with the same values by key [duplicate]

Question

Please help. I am creating an API and this is the data structure that Iam trying to achive:

Groups:[{ groupId, name, members:[{userId, first_name, last_name, joinedDate, leftDate}] }] The members filed shoud contain all users that have the same groupId I need to group this input by groupId:

[ { groupId    : 1
  , name       : 'test group'
  , userId     : 2
  , first_name : 'Ross'
  , last_name  : 'Geller'
  , joinedDate : 2022-01-13T13: 25: 43.510Z
  , leftDate   : 2023-02-24T19: 07: 11.110Z
  } 
, { groupId    : 12
  , name       : 'test group 2'
  , userId     : 2
  , first_name : 'Ross'
  , last_name  : 'Geller'
  , joinedDate : 2022-01-13T00: 00: 00.000Z
  , leftDate   : null
  } 
, { groupId    : 12
  , name       : 'test group 2'
  , userId     : 6
  , first_name : 'Joey'
  , last_name  : 'Tribbiani'
  , joinedDate : 2022-01-13T00: 00: 00.000Z
  , leftDate   : null
  } 
]

Into this output:

[ { groupId : 1
  , name    : 'test group'
  , members: 
    [ { userId     : 5
      , first_name : 'Monica'
      , last_name  : 'Gellar'
      , joinedDate : 2022-01-13T13: 25: 43.510Z
      , leftDate   : null
  } ] } 
, { groupId : 12
  , name    : 'test group 2'
  , members: 
    [ { userId     : 2
      , first_name : 'Ross'
      , last_name  : 'Geller'
      , joinedDate : 2022-01-13T00: 00: 00.000Z
      , leftDate   : null
      } 
    , { userId     : 6
      , first_name : 'Joey'
      , last_name  : 'Tribbiani'
      , joinedDate : 2022-01-13T00: 00: 00.000Z
      , leftDate   : null
} ] } ]

I looked at bunch of examples that uses reduce and map. But I could not figure out how to implement it to this project. — Alex
– Alex, Commented Mar 15, 2023 at 23:02

grimsteel · Accepted Answer · 2023-03-15 23:39:27Z

3

You can use Array.prototype.reduce:

const members = [
  {
    groupId: 1,
    name: 'test group',
    userId: 2,
    first_name: 'Ross',
    last_name: 'Geller',
    joinedDate: "2022-01-13T13:25:43.510Z",
    leftDate: "2023-02-24T19:07:11.110Z"   
  },
  {
    groupId: 12,
    name: 'test group 2',
    userId: 2,
    first_name: 'Ross',
    last_name: 'Geller',
    joinedDate: "2022-01-13T00:00:00.000Z",
    leftDate: null
  },
  {
    groupId: 12,
    name: 'test group 2',
    userId: 6,
    first_name: 'Joey',
    last_name: 'Tribbiani',
    joinedDate: "2022-01-13T00:00:00.000Z",
    leftDate: null
  }
];

const grouped = members.reduce((acc, { groupId, name, ...member }) => {
  const existingGroup = acc.find(group => group.groupId === groupId);
  if (existingGroup)
    existingGroup.members.push(member);
  else
    acc.push({
      groupId,
      name,
      members: [
        member
      ]
    });
  return acc;
}, []);

console.log(grouped);

edited Mar 15, 2023 at 23:39

answered Mar 15, 2023 at 23:08

grimsteel

1,4106 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alex Over a year ago

Thank you, that impressive I spent 4 hours and you did it in 5 min. Nice!!! that is almost what I need, except members should not include information about the group. it should be only userId, first_name, last_name, joinedDate, leftDate. If you could help me to achive that I will appreciate it!

grimsteel Over a year ago

@Alex I updated my answer. You can also check stackoverflow.com/a/56156100 for more information on removing properties

Collectives™ on Stack Overflow

Merge array of objects with the same values by key [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related