Database

[{"_id":7499,"CommitId":"dee196c8-8a7b-d146-b1e8-f5c7279f056e","CommitStamp":ISODate("2017-11-01T05:58:40.331Z"),"Headers":[["AggregateType","Kimo.Engine.Model.Documents.Document"],["command.timestamp","2017-11-01T05:58:40.3318022Z"]],"Events":[{"StreamRevision":1,"Payload":{"Headers":{},"Body":{"_t":"DocumentCreatedFromMobile_1","MessageId":"70dbc516-9f0e-8c4d-a502-3876c5f09309","AggregateId":"Document_49","Code":"Document_49","Info":{"DocumentMarkup":"0.0","DocumentMarkupOnNetCost":"100.0","Lines":[{"LineMarkup":"0.0","LineMarkupOnNetCost":"100.0"}]},"UserId":{"_id":"User_4"},"CreationDate":ISODate("2017-10-31T10:00:55.000Z"),"MobileId":"C896E1DE-7B8A-46D1-B1E8-F5C7279F056E","UploadToServerTimeStamp":ISODate("2017-11-01T05:58:40.331Z")}}},{"StreamRevision":2,"Payload":{"Headers":{},"Body":{"_t":"DocumentArchivedFromMobile_1","MessageId":"310473ef-9d23-9242-a483-fa8daed06cbf","AggregateId":"Document_49","MobileId":"C896E1DE-7B8A-46D1-B1E8-F5C7279F056E","SyncReference":null,"Info":{"DocumentMarkup":"0.0","DocumentMarkupOnNetCost":"100.0","Lines":[{"LineMarkup":"0.0","LineMarkupOnNetCost":"100.0"}]},"UserId":{"_id":"User_4"},"LastModifiedTimeStamp":ISODate("2017-10-31T10:00:55.000Z"),"UploadToServerTimeStamp":ISODate("2017-11-01T05:58:40.331Z")}}}],"Dispatched":false,"StreamRevisionFrom":1,"StreamRevisionTo":2,"BucketId":"Kimo","StreamId":"Document_49","CommitSequence":1}]

Query

db.collection.update({},[{$set:{Events:{$map:{input:"$Events",in:{$mergeObjects:["$$this",{Payload:{$mergeObjects:["$$this.Payload",{Body:{$mergeObjects:["$$this.Payload.Body",{Info:{$mergeObjects:["$$this.Payload.Body.Info",{DocumentSaleMargin:"$$this.Payload.Body.Info.DocumentMarkupOnNetCost",Lines:{$map:{input:"$$this.Payload.Body.Info.Lines",as:"l",in:{$mergeObjects:["$$l",{LineSaleMargin:"$$l.LineMarkupOnNetCost"}]}}}}]}}]}}]}}]}}}}},{$unset:["Events.Payload.Body.Info.DocumentMarkupOnNetCost","Events.Payload.Body.Info.DocumentMarkupAmountOnNetCost","Events.Payload.Body.Info.Lines.LineMarkupOnNetCost","Events.Payload.Body.Info.Lines.LineMarkupAmountOnNetCost"]}])

Result