Merge mongodb arrays in one array with aggregation

Question

I want to display the following result

[
  {
    "MergedTabs": [1,2,3,4,5,6],
    "name": "John"
  }
]

from the collection below

[
  {
    "name":"John",
    "tab":[1,2,3]
  },
  {
    "name":"John",
    "tab":[4,5,6]
  }
]

I tried the query below but I doesn't display what I want

db.collection.aggregate([
  {
    "$group": {
      "_id": "$name",
      "MergedTabs": {
        "$push": "$tab"
      }
    }
  },
    {
    "$project": {
      "name": "$_id",
      "MergedTabs": 1
    }
  }
])

Any ideas how to solve it please ? Thanks

Unwind it and group it

varman
– varman

2021-10-12 13:57:13 +00:00
Commented Oct 12, 2021 at 13:57 — varman
– varman, Commented Oct 12, 2021 at 13:57

varman · Accepted Answer · 2021-10-12 14:03:50Z

1

    db.collection.aggregate([
  {
    $unwind: "$tab"
  },
  {
    $group: {
      _id: "$name",
      mergedTab: {
        $push: "$tab"
      }
    }
  },
  {
    $project: {
      name: "$_id",
      mergedTab: 1,
      _id: "$$REMOVE"
    }
  }
])

answered Oct 12, 2021 at 14:03

varman

8,9226 gold badges25 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Merge mongodb arrays in one array with aggregation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related