Concat Arrays on all fields MongoDB

Question

Imagine I have this collection:

{
  id: 1,
  b: { 
   "field1": ['foo'],
   "field2": ['bar']
  }
}
{
  id: 2,
  b: { 
   "field2": ["foobar"],
   "field3": ["foofoo"]
  }
}

And I want to obtain a new collection with MongoDB:

{
 id: 1,
 b_grouped: ['foo', 'bar']
}
{
 id: 2,
 b_grouped: ["foobar", "foofoo"]
}

I don't know all the name of the fields in the documents, anyone would have an idea of how to perform something like this:

db.collection.aggregate(
   [
      { "$project": { "b_grouped": { $concatArrays: ["$b.*"] } } }
   ]
)

Your sample data is not valid JSON. Are these two documents or just one? — Wernfried Domscheit
– Wernfried Domscheit, Commented Oct 23, 2020 at 11:30
I got confused while writing it, I fixed it and it is actually two documents — aja228
– aja228, Commented Oct 23, 2020 at 12:09

turivishal · Accepted Answer · 2020-10-23 11:34:42Z

10

You can try,

$reduce input b as a array after converting from object to array using $objectToArray, this will convert object in "k" (key), "v" (value) format array of object,
$concatArrays to concat initialValue ($$value) of $raduce and array of b object's field $$this.v

db.collection.aggregate([
  {
    $project: {
      b_grouped: {
        $reduce: {
          input: { $objectToArray: "$b" },
          initialValue: [],
          in: {
            $concatArrays: ["$$this.v", "$$value"]
          }
        }
      }
    }
  }
])

Playground

edited Oct 23, 2020 at 11:34

answered Oct 23, 2020 at 11:29

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Concat Arrays on all fields 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