How flatten an array of arrays using aggregate

Question

I'm trying to use aggregate framework of MongoDB(3.6) to flatten the following data:

array = [
  [1899.99, 241.92, 869.99, 696],
  [2301.45, 100],
  [1468.12, 85.9],
  [14.1],
  [268.59, 27.6, 428.51, 173.85],
  [627.29, 241.92, 413.47, 229.74],
  [1687.58, 100],
  [241.11]
]

And what I need is:

result = [1899.99, 241.92, 869.99, 696, 2301.45, 100, 1468.12, 85.9, 14.1, 268.59, 27.6, 428.51, 173.85, 627.29, 241.92, 413.47, 229.74, 1687.58, 100, 241.11]

I'm using this query:

db.collection.aggregate([
  {
    $match: { code: '11122233344' }
  },
  {
    $project: {
      vencimentos: '$response.operations.expirations.value'
    }
  },
  {
    $unwind: '$vencimentos'
  },
  {
    $group: {
      _id: 'vencimentos',
      vencimentos: { $addToSet: '$vencimentos' }
    }
  },
])

And this is the result of query:

{
  "_id" : "vencimentos",
  "vencimentos" : [
    [1899.99, 241.92, 869.99, 696.11],
    [2301.45, 100],
    [1468.12, 85.9],
    [14.1],
    [268.59, 27.6, 428.51, 173.85],
    [627.29, 241.92, 413.47, 229.74],
    [1687.58, 100],
    [241.11]
  ]
}

Anyone can help me? Thanks.

matthPen · Accepted Answer · 2021-02-18 21:44:47Z

2

Considering the result of your current aggregation, you have to add the following step to get what you need :

{
    $addFields: {
      vencimentos: {
        "$reduce": {
          "input": "$vencimentos",
          "initialValue": [],
          "in": {
            "$concatArrays": [
              "$$this",
              "$$value"
            ]
          }
        }
      }
    }
  }

You can test the result here

answered Feb 18, 2021 at 21:44

matthPen

4,3731 gold badge18 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

How flatten an array of arrays using aggregate

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