i have some data structured like this :

        "location_identifiers": [
            {
                "permalink": "olivette-missouri",
                "uuid": "e1774b1c-634d-4ea4-1414-cd8be15df631",
                "location_type": "city",
                "entity_def_id": "location",
                "value": "Olivette"
            },
            {
                "permalink": "missouri-united-states",
                "uuid": "51a065b8-05d5-1a28-3fcd-1ad143f1f725",
                "location_type": "region",
                "entity_def_id": "location",
                "value": "Missouri"
            }

i want to restructure it to look like this, i am using mongodb compass:

"location_identifiers": [
            {
                "city": "Olivette",
                "region": "Missouri"
            }
]

i have tried unwind and project query but i am stuck, any help would be greatly appreciated.

CodePudding user response：

Use $arrayToObject

db.collection.aggregate([
  {
    "$match": {}
  },
  {
    "$set": {
      "location_identifiers": [
        {
          "$arrayToObject": {
            "$map": {
              "input": "$location_identifiers",
              "as": "item",
              "in": {
                k: "$$item.location_type",
                v: "$$item.value"
              }
            }
          }
        }
      ]
    }
  }
])

mongoplayground