Hi @RCHEST ,
Thanks for posting query in Microsoft Q&A Platform.
So, here you are basically trying to combine two columns as one column using Azure data factory.
You should consider using data flows and use derived column transformation in it to achieve same.
When creating a derived column, you can either generate a new column or update an existing one. Click here to know more about how to create a new column or update an existing column using derived column transformation.
Below video also helps you to understand derived column transformation.
Derived Column Transformation in Mapping Data Flow in Azure Data Factory
Hope this helps. Please let us know if any further queries.
Please consider hitting
Accept Answer button. Accepted answers help community as well.