Database
[{PartnerName:"Company A",MarketExpertese:[{Sector:{Code:1,TotalYears:1,TotalMonths:20,TotalClients:10}},{Sector:{Code:2,TotalYears:2,TotalMonths:20,TotalClients:10}},{Sector:{Code:3,TotalYears:3,TotalMonths:20,TotalClients:10}}]}]
Query
db.collection.aggregate([{$match:{}},{$project:{"_id":0,"PartnerName":1.0,"Teste":{"$map":{"input":"$MarketExpertese","as":"el","in":"$$el.Sector.Code"}}}}])/**
What I want:* [* {* "PartnerName": "Company A",* "Teste": [* {"SectorCode": 1, "TotalYears": 1},* {"SectorCode": 2, "TotalYears": 2},* {"SectorCode": 3, "TotalYears": 3},* ]* }
]**/