db={"doc1":[{"version":123456,"doc":{"code":"A1","name":"some document A1","doc2CodeArray":[{"code":"B01"},{"code":"B02"},{"code":"B03"},{"code":"B04"},{"code":"B05"},{"code":"B06"}]}},{"version":123457,"doc":{"code":"A2","name":"some document A2","doc2CodeArray":[{"code":"B07"},{"code":"B08"},{"code":"B09"},{"code":"B10"},{"code":"B11"},{"code":"B12"}]}}],"doc2":[{"version":567890,"doc":{"code":"B01","valueArray":[{"valueType":"int","valueData":"1"}],"doc2Type":{"code":"C1"}}},{"version":567890,"doc":{"code":"B02","valueArray":[{"valueType":"int","valueData":"2"}],"doc2Type":{"code":"C2"}}},{"version":567890,"doc":{"code":"B03","valueArray":[{"valueType":"int","valueData":"3"}],"doc2Type":{"code":"C3"}}},{"version":567890,"doc":{"code":"B04","valueArray":[{"valueType":"int","valueData":"4"}],"doc2Type":{"code":"C4"}}},{"version":567890,"doc":{"code":"B05","valueArray":[{"valueType":"int","valueData":"5"}],"doc2Type":{"code":"C5"}}},{"version":567890,"doc":{"code":"B06","valueArray":[{"valueType":"int","valueData":"6"},{"valueType":"str","valueData":"F"}],"doc2Type":{"code":"C6"}}},{"version":567890,"doc":{"code":"B07","valueArray":[{"valueType":"int","valueData":"1"}],"doc2Type":{"code":"C1"}}},{"version":567890,"doc":{"code":"B08","valueArray":[{"valueType":"int","valueData":"2"}],"doc2Type":{"code":"C2"}}},{"version":567890,"doc":{"code":"B09","valueArray":[{"valueType":"int","valueData":"3"}],"doc2Type":{"code":"C3"}}},{"version":567890,"doc":{"code":"B10","valueArray":[{"valueType":"int","valueData":"4"}],"doc2Type":{"code":"C4"}}},{"version":567890,"doc":{"code":"B11","valueArray":[{"valueType":"int","valueData":"5"}],"doc2Type":{"code":"C5"}}},{"version":567890,"doc":{"code":"B12","valueArray":[{"valueType":"int","valueData":"6"}],"doc2Type":{"code":"C6"}}}]}

db.doc1.aggregate([{$lookup:{from:"doc2",localField:"doc.doc2CodeArray.code",foreignField:"doc.code",as:"doc.doc2Items"}},{$replaceRoot:{newRoot:"$doc"}},{$addFields:{"doc2Items":{$map:{input:"$doc2Items",in:{doc2TypeCode:"$$this.doc.doc2Type.code",doc2ValueArray:"$$this.doc.valueArray"}}}}},{$unset:["doc2CodeArray"]}])