#64. Azure Data Factory - Add Additional columns to the source columns in Copy Activity

While we copy records from source to destination, we might want to add some additional details to the incoming rows. For instance, we might want to mention the name of the file or path of the file or current timestamp, etc. This session takes you through the steps required to add additional columns in Source tab of Copy activity.

[oriono]

Somuch Informative and explained very well

[ShriramVasudevan]

Lovely content and the channel is providing a lot of real good info..

[naveenshindhe]

Thanks for the video, is it possible to add the columns in Table..

[gosmart_always]

In the interface of ADF, there is no option to change type of a column(both for source and target) in mapping section of copy activity. How can we achieve it ?

[chinmaykshah]

Hello madam, how to add additional column in copy activity that i got it but how can we add expression in new column eg. first name new column and use substring(firstname, 0, 1) or complext data type like list<string> how to add in copy activity?

[harinis]

Can you pls advice if I can use any expression to create a new column by either using a substring or replace function of one of source column?

[poluhk]

Mem I have question on this, source file have 10 columns and sink have 5 columns, how we can achieve this. Please make a video for this

[jamshedsalik]

I want to add username in additional column who initiate or debug the pipeline. so we will know
who is login and debug the pipeline.

[vru]

Hello Madam,

If I wanted to additional column as rowcount which will give me no of rows in source file. How can we fetch that like in case of table we can do select count(*)

Kindly help

[jamshedsalik]

Hello madam,  
Make a video on scenarios that have additional columns coming from the source .
Example:

(column)
ID, Name, Age

(column)
ID, Name, Age, PhoneNumber

(column)
ID, Name, Age, PhoneNumber, DateofBirth


And destination table in azure sql have only these column 
Destination table: 
ID, Name, Age

How can we handle incremental columns in the Azure data factory?