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.
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.
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.
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 - ua-cam.com/video/OE6nbm4wlkw/v-deo.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
You are my favorite ADF resource. Clear and well-designed problems in each video. Thank you.
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.
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?
Thanks! Sir, for your GREAT effort for us.
God Bless You
Thank you 🙂
Very understandable to new learners. Thank you for your sharing^^
Welcome 😊
What a wonderful efforts you are putting in..
Thank you 😊
very very helpful. Thanku soo much for this Demo
Thank you 🙂
Thanks Wafa
The channel which i used to start my Datafactory with zero to medium level
Thank you 🙂
Awesome...Grate effort Maheer
Thank you 🙂
Awesome...Grate effort Bro
Thank you🙂
Nice video...keep posting..
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
THANK YOU VERY GOOD RESOURCE !
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
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.
Thanks for the video, You have added the new columns in file, is it possible to add the columns in Table, Thanks
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.
nice video sir,
present this option is not there in copy activity
My additional column is not appearing when I map, any idea?
Sir any way to copy data frm access db to sql using adf copy function
Can we add file_name using data flow activity? I tried by using derived column but no luck
can we add sequence number like this
Is there any way to add those columns at beginning not at end
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 - ua-cam.com/video/OE6nbm4wlkw/v-deo.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
Are getting names with data type?
I want only names not data type name. How should I get that?
Can we use derivee column here
How to rename attributes from source