Azure Copy Activity: Concate two source columns

Question

Hi,

Is it possible to concatenate two source columns into one sink column using Azure Data Factory Copy Activity.

Thanks
Abhishek

Answer 1

Hi @Abhishek Vyas ,

Thanks for the ask and using Microsoft Q&A forum.

Unfortunately copy activity in ADF is not intended for transformations, hence the answer is no. It is used to copy data among data stores located on-premises and in the cloud. After you copy the data, you can use other activities like Mapping data flow (just an example) to further transform and analyze it.

If you want to transform the data while copying from source to sink, then Mapping data flow activity is the correct solution which supports various transformations as listed here: Mapping data flow transformation overview

Within mapping data flow, Derived column transformation suits well for your requirement.

Hope this info helps. Do let us know if you have further query.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.