Hi @Abdul Kalam Mulla ,
Thank you for posting query in Microsoft Q&A Platform.
If I understand correctly, you would like to concatenate two columns and then load to sink using copy activity. Please correct me If my understanding is incorrect.
Copy activity cannot perform any kind of data transformations or data manipulations. It will only allow us to perform Data movement. Your scenario cannot be done using copy activity. You can consider using Dataflows for this kind of transformations.
In Data flows consider using derived column transformation for implementing your scenario of concatenation.
Below are few useful resources to refer.
- Mapping data flows in Azure Data Factory
- Derived column transformation documentation
- Video which explains Derived Column transformation
Hope this helps. Please let us know if any further queries.
------------
Please consider hitting Accept Answer
. Accepted answers help community as well.