Perform MongoDB array concatenation to concatenate records

For array concatenation, use $concatArrays operator. Let us first create a collection with documents −

>db.arrayConcatenationDemo.insertOne({"TeacherName":["Chris","Robert"],"StudentName":["Mike","Sam"]});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ce921c078f00858fb12e911")
}

Following is the query to display all documents from a collection with the help of find() method −

> db.arrayConcatenationDemo.find().pretty();

This will produce the following output −

{
   "_id" : ObjectId("5ce921c078f00858fb12e911"),
   "TeacherName" : [
      "Chris",
      "Robert"
   ],
   "StudentName" : [
      "Mike",
      "Sam"
   ]
}

Following is the query for array concatenation −

> db.arrayConcatenationDemo.aggregate([
   { "$project": {
      "StudentAndTeacherName": { "$concatArrays": [ "$TeacherName", "$StudentName" ] }
   }}
]);

This will produce the following output −

{ "_id" : ObjectId("5ce921c078f00858fb12e911"), "StudentAndTeacherName" : [ "Chris", "Robert", "Mike", "Sam" ] }

Smita Kapse

Updated on 30-Jul-2019 22:30:26

• Related Questions & Answers
• MongoDB query for array concatenation?
• How to perform string aggregation/concatenation in Oracle?
• MongoDB query to concatenate values of array with other fields
• Concatenate fields in MongoDB?
• How to concatenate results in MongoDB?
• Concatenate with condition in MongoDB?
• Perform $lookup to array of object id's in MongoDB?
• Find MongoDB records where array field is not empty?
• C++ program to get length of strings, perform concatenation and swap characters
• How can I concatenate an array of integer in MongoDB aggregation method?
• Display and concatenate records ignoring NULL values in MySQL
• Perform aggregation sort in MongoDB?
• Perform MongoDB full text search
• Perform Bulk insert in MongoDB?
• Perform simple validation in MongoDB?