Normalized the Array structure into Multiple documents in mongoDB

Question

Input is Once Document

{
  "name": [
    "abc",
    "xyz"
  ],
  "values": [
    "123",
    "100"
  ]
}

The explanation I want to Normalize the Array into multiple documents, abc, and xyz are dynamically coming, these are user define parameters

Expected Output

[
    {
        "data": {
            "name": "abc",
            "values": "123"
        }
    },
    {
        "data": {
            "name": "xyz",
            "values": "100"
        }
    }
];

Can there be more values in name and values array? Can they mismatch in size? — Dheemanth Bhat
– Dheemanth Bhat, Commented Mar 1, 2021 at 14:23
No, they cannot mismatch the size, the Array length of the values and name should be the same. — bc110402922
– bc110402922, Commented Mar 1, 2021 at 14:25
the array count can be more, but the count should be the match of both arrays — bc110402922
– bc110402922, Commented Mar 1, 2021 at 14:26

Tom Slabbaert · Accepted Answer · 2021-03-01 14:44:41Z

1

What you want to do is use $zip, like so:

db.collection.aggregate([
  {
    $project: {
      data: {
        $map: {
          input: {
            $zip: {
              inputs: [
                "$name",
                "$values"
              ]
            }
          },
          as: "zipped",
          in: {
            name: {
              "$arrayElemAt": [
                "$$zipped",
                0
              ]
            },
            values: {
              "$arrayElemAt": [
                "$$zipped",
                1
              ]
            }
          }
        }
      }
    }
  },
  {
    $unwind: "$data"
  },
  {
    $replaceRoot: {
      newRoot: {
        data: "$data"
      }
    }
  }
])

Mongo Playground

answered Mar 1, 2021 at 14:44

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

Comments

Dheemanth Bhat · Accepted Answer · 2021-03-01 14:59:54Z

1

Try this:

db.testCollection.aggregate([
    {
        $project: {
            "data": {
                $map: {
                    input: { $zip: { inputs: ["$name", "$values"] } },
                    as: "item",
                    in: {
                        name: { $arrayElemAt: ["$$item", 0] },
                        values: { $arrayElemAt: ["$$item", 1] }
                    }
                }
            }
        }
    },
    { $unwind: "$data" }
]);

answered Mar 1, 2021 at 14:59

Dheemanth Bhat

4,5022 gold badges30 silver badges43 bronze badges

Collectives™ on Stack Overflow

Normalized the Array structure into Multiple documents in mongoDB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related