I am trying to copy form Azure Table Storage to Azure CosmosDb sql Api using Azure Data Factory V2. During copy I want to add a new field (column) to each document by concatenating two of the column values from table. E.g. my table has 2 columns imageId and tenantId and I want to make the id of document in cosmos db like image_tenant_ImageID_TenantID.
For this I am trying to add dynamic content for "Additional Columns" under "Source" in the ADF but couldn't figure out how to do that. Can anyone please help with this?