My job is to move data from my container in CosmosDb to another container in same database. In my new container I have defined my partition key as /PKey but the documents to be moved does not have a key named as "PKey". I would like to create this key while moving the document to new container and this PKey will contain value by concanateing few of my key values in the document(for e.g. PKey:"will be combination of Id and name key in the document").
So if my Source document is : {Name: "ZZZ", ID: 21} My target will be {Name: "ZZZ", ID: 21, PKey: "ZZZ21"}
I would like to know if this possible in Data factory which I have selected for this copy activity , i.e. if I can create a Key on the fly while moving documents.Thanks
