How to combine two objects in mongodb aggregation project stage?

Question

I had the following array of structure in my aggregation pipeline. Tried merge objects and setUnion operators.

{ 
  combs:[
    [
      {
        name:"A",
        c_type:"A"
      },
      {
        type:"visual",
        severity:"Normal"
      }
    ],
    [
      {
        name:"B",
        c_type:"B"
      },
      {
        type:"visual",
        severity:"Normal"
      }
    ]
  ]
}

I am expecting the following results to produce some statistics. Please help me.

{ 
  combs:[
    {
      name:"A",
      c_type:"A",
      type:"visual",
      severity:"Normal"
    }
    {
      name:"B",
      c_type:"B",
      type:"visual",
      severity:"Normal"
     }
  ]
}

Neil Lunn · Accepted Answer · 2019-09-23 06:30:10Z

"Is it possible to achieve without $unwind operation?"

Well YES. As long as your structure of arrays of arrays is consistently mapped that way then you really only need a single stage in the pipeline:

db.collection.aggregate([
  { "$addFields": {
     "combs": {
       "$map": {
         "input": "$combs",
         "in": { "$mergeObjects": "$$this" }
       }
     }
  }}
])

So really the $map operator takes place here as a much more efficient method than $unwind for processing each array element. Also since $mergeObjects is expecting "an array of objects", this is what each element of your array of arrays actually is. So simply { "$mergeObjects": "$$this" } on each outer member of the array.

Produces the output from your supplied data:

{
        "_id" : ObjectId("5d8865c273375a6a4cc9e76a"),
        "combs" : [
                {
                        "name" : "A",
                        "c_type" : "A",
                        "type" : "visual",
                        "severity" : "Normal"
                },
                {
                        "name" : "B",
                        "c_type" : "B",
                        "type" : "visual",
                        "severity" : "Normal"
                }
        ]
}

Generally you should always prefer an inline processor like $map or other array operators in preference to $unwind where applicable.

Ashok · Accepted Answer · 2019-09-23 05:50:13Z

0

You can use this aggregation query

db.collection.aggregate([
     { $unwind: "$combs" },
     { $addFields: { combs: { $mergeObjects: "$combs" }}},
     { $group: { _id: "$_id", combs: { $push: "$combs" }} }
 ])

answered Sep 23, 2019 at 5:50

Ashok

2,9621 gold badge15 silver badges21 bronze badges

1 Comment

Krishna Dev Over a year ago

Is it possible to achieve without $unwind operation? @Ashok

Collectives™ on Stack Overflow

How to combine two objects in mongodb aggregation project stage?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related