It is possible to add "Additional Columns" to Azure Data Factory in Copy Activity?

Question

Hi,
for adding Additional columns there is a section "Add dynamics content" so can I add a additional column that base on a column my additional column will have one value or other?

let me write like a raw example:

if column == null 'YES' else 'NO'

Answer 1

Hey,
Based on my knowledge, the additional columns in the copy activity are static values which you can add like pipeline parameters etc.
It is not possible to have expression based columns as additional columns.
For that you would need to use dataflow wherein you can create derived columns.

@HimanshuSinha-msft @KranthiPakala-MSFT @PRADEEPCHEEKATLA : Please correct me if I am wrong

Answer 2

Hello @Pablo CR ,

Welcome to the Microsoft Q&A platform. Thanks for the question.

In addition to the @Nandan Hegde response.

With ADF copy activity you can choose to add additional columns to copy along to sink, including static value, dynamic content with ADF expression, and source files’ path.

For more details, refer to Azure Data Factory - Add additional columns during copy.

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.