Convert Object To array mongoDB

Question

Document 1: Need to covert object to Arrays. I have to iterate on each element of the key and value, how I can convert from an object to Array.

{
  "Data":{
    "A" :{
      "name" : alpha,
      "Score" : 199
    },
    "B" :{
      "name" : Beta,
      "Score" : 122
    }
  }
}

Expected Output :

{
  "name" :[
    alpha,
    Beta
  ],
  "score": [
    199,
    122
  ]
}

Hussam · Accepted Answer · 2021-07-07 13:56:01Z

1

You can achieve this using mongo aggregation framework.

[
  {
    "$addFields": {
      "Data": {
        "$objectToArray": "$Data"
      }
    }
  },
  {
    $unwind: "$Data"
  },
  {
    "$group": {
      "_id": "_id",
      "name": {
        $push: "$Data.v.name"
      },
      "score": {
        $push: "$Data.v.Score"
      },
      
    }
  }
]

Mongo Playground: https://mongoplayground.net/p/JVTW5rEoJoa

answered Jul 7, 2021 at 13:56

Hussam

1,72612 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Convert Object To array mongoDB

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