Mongodb Aggregate: Combine multiple keys into an array

Question

I want to combine three keys in my documents to an array using mongodb aggregate. Here is an example of what I am trying to accomplish:

Input Document:

{  
    _id: "xyz", 
    p1: "A", 
    p2: "E", 
    p3: "C"
}

Output Document:

{ 
   _id: "xyz",
   p: ["A", "E", "C"] 
}

Does anyone have an idea how to accomplish this using mongodb aggregate?

Cheers J

whoami - fakeFaceTrueSoul · Accepted Answer · 2020-05-11 16:11:32Z

3

Using aggregation's $project stage, You can do as like below :

db.collection.aggregate([
  {
    $project: { p: [ "$p1", "$p2", "$p3" ] }
  }
])

Test : mongoplayground

answered May 11, 2020 at 16:11

18.1k6 gold badges35 silver badges51 bronze badges

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

1 Answer 1