question

AbhishekVyas-4546 avatar image
0 Votes"
AbhishekVyas-4546 asked KranthiPakala-MSFT commented

Azure Copy Activity: Concate two source columns

Hi,

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


Thanks
Abhishek

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @AbhishekVyas-4546 ,

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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.



I have already implemented using Data-flow. But the problem is dataflow takes time to execute.

0 Votes 0 ·

Thanks for your response @AbhishekVyas-4546. As it is not possible with copy activity, the only alternate is Mapping data flow. If you have any suggestion regarding this, I would recommend you to please submit your feedback in ADF user voice forum - https://feedback.azure.com/forums/270578-data-factory. All the feedback shared in this forum are monitored and reviewed by ADF engineering team.

Do let us know if you have further query.

Thank you

1 Vote 1 ·