Using MongoDB Aggregation to merge two lists into an object

Question

I'm using mongoDB and I have documents similar to the following

{
  "files": ["Customers", "Items", "Contacts"],
  "counts": [1354, 892, 1542],
  ...
}

And using an aggregation pipeline stage, I want to convert the above into something more like..

{
  "file_info": [
    {"file_name": "Customers", "record_counts": 1354},
    {"file_name": "Items", "record_counts": 892},
    {"file_name": "Contacts", "record_counts": 1542}
  ]
}

I've tried using $map, $reduce, and $arrayToObject but without any success. What operators can I use to get from where I currently am to where I need to be?

mickl · Accepted Answer · 2020-06-17 18:19:04Z

2

You can use $zip to combine two arrays and $map to get the new structure:

{
    $project: {
        file_info: {
            $map: {
                input: { $zip: { inputs: [ "$files", "$counts" ] } },
                in: {
                    file_name: { $arrayElemAt: [ "$$this", 0 ] },
                    record_counts: { $arrayElemAt: [ "$$this", 1 ] },
                }
            }
        }
    }
}

Mongo Playground

answered Jun 17, 2020 at 18:19

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

1 Comment

Bitsplease Over a year ago

Just tested and this works beautifully, thank you! Also thank you for introducing me to mongoplayground, very helpful tool!

Collectives™ on Stack Overflow

Using MongoDB Aggregation to merge two lists into an object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related