13. Add additional columns during copy in Azure Data Factory

In this video, I discussed about adding additional columns during copy in Azure Data Factory

#Azure #ADF #AzureDataFactory

[max]

I've been researching adding additional columns to the output for a week and finally a video of what I want to do. Thank you very much sir from a new subscriber.

[payalkalantri]

How can we implement functions in additional columns like utcnow(), int ... If I am trying to use it throws error like expected array but got string...Could you pleas ehelp?

[papachoudhary]

Thanks! Sir, for your GREAT effort for us.
God Bless You

[vlnreddy]

Thanks You very much for such a great video. Please let us know how to add additional columns for database source to database sink

[pushkaljaiswal]

I have a Column like date and i have to derive and make it as a datekey and add as a column can i do that here without using Data flow.

[yuuellie]

Very understandable to new learners. Thank you for your sharing^^

[santoshnagargoje]

Sir any way to copy data frm access db to sql using adf copy function

[alexfernandodossantossilva]

My additional column is not appearing when I map, any idea?

[MaheshReddyPeddaggari]

The channel which i used to start my Datafactory with zero to medium level

[pratikshakapse]

very very helpful. Thanku soo much for this Demo

[superfisherable]

You are my favorite ADF resource. Clear and well-designed problems in each video. Thank you.

[shaileshsondawale]

What a wonderful efforts you are putting in..

[tharunsangaraju]

Hi, How can we append two columns using additional columns. Here we are using $$column and loading for only any one column requirmrnt for two column add need to be appended.

[sabasehreen]

Suppose we have 3 column in source file and in table we have 4 column in the sink. And we want to do one to one mapping for that and the addition column in sink we should get it as NULL while mapping it is possible?if yes.. Can you say the steps for that.

[sudipmazumdar]

Always learning new things from your videos. Really appreciate the effort you have put in for making these.

[naveenshindhe]

Thanks for the video, You have added the new columns in file, is it possible to add the columns in Table, Thanks

[abhisheknagar]

Can we add file_name using data flow activity? I tried by using derived column but no luck

[johnpaulprathipati]

nice video sir,
present this option is not there in copy activity

[jasmineshalini]

Is there any way to add those columns at beginning not at end

[antonymjellis]

Hi great channel but can I ask... is there anyway within a copy activity to reference an existing source column and enclose within an expression? Within the new "additional column" field apart from system variables I see now way to do this without having to go down a data flow/derived column route. It seems a shame because all I wanted to do was to convert a date from a CSV into a date so that ADF does not throw an error when trying to sink to a date field within D365. E.g. where [] is a source field.?