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.
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.
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?
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.
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. @formatDateTime([date_of_validation]) where [] is a source field.?
Hi, I faced similar issue as you. After digging deeper, the answer is 'no, we cant'. There is a great explanation in this video I found - th-cam.com/video/OE6nbm4wlkw/w-d-xo.html
Thank you, this helps. I am trying something similar but my target is an existing SQL table. I added additional columns in source but it does not show up in mapping, any idea on this ? Thanks for your help
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.
You are my favorite ADF resource. Clear and well-designed problems in each video. Thank you.
Always learning new things from your videos. Really appreciate the effort you have put in for making these.
Thank you ☺️
@@WafaStudies Thanks for the cool videos. what if you have more than one files?
What a wonderful efforts you are putting in..
Thank you 😊
Thanks! Sir, for your GREAT effort for us.
God Bless You
Thank you 🙂
Very understandable to new learners. Thank you for your sharing^^
Welcome 😊
can this value be integer ? or it supports only string ?
Awesome...Grate effort Maheer
Thank you 🙂
very very helpful. Thanku soo much for this Demo
Thank you 🙂
Thanks You very much for such a great video. Please let us know how to add additional columns for database source to database sink
It will be same. I used blob datasets. In your case use db datasets
How to create an additional column from an ordinal column where there it NO header? I can't seem to find anything on this.
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.
Awesome...Grate effort Bro
Thank you🙂
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?
Thanks for the video, You have added the new columns in file, is it possible to add the columns in Table, Thanks
The channel which i used to start my Datafactory with zero to medium level
Thank you 🙂
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.
Is there any way to add those columns at beginning not at end
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.
Think I am asking a similar question... did you find a way without using a data flow/derived column?
@@antonymjellis yes we can do easily
@@parthnigam1782 can u explain how it is , thanks
Can we use derivee column here
Nice video...keep posting..
Can we add file_name using data flow activity? I tried by using derived column but no luck
Sir any way to copy data frm access db to sql using adf copy function
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. @formatDateTime([date_of_validation]) where [] is a source field.?
Hi, I faced similar issue as you. After digging deeper, the answer is 'no, we cant'. There is a great explanation in this video I found - th-cam.com/video/OE6nbm4wlkw/w-d-xo.html
can we add sequence number like this
Thank you, this helps.
I am trying something similar but my target is an existing SQL table. I added additional columns in source but it does not show up in mapping, any idea on this ?
Thanks for your help
Are getting names with data type?
I want only names not data type name. How should I get that?
THANK YOU VERY GOOD RESOURCE !
nice video sir,
present this option is not there in copy activity
My additional column is not appearing when I map, any idea?
You have to click "Import Schemas" on mapping tab to see new add'l columns.
How to rename attributes from source
Thanks Wafa