hi brother,, doest it require to add .firstRow.FoderName part in dataset parameter value in case 1 , i guess it is already filtering the required folder name from activity output by enabling only first row option, so why to hardcode again entire parameter value with firstrow.FolderName, @activity('Lookup')output.firstRow.FoderName) it means it cannot just give the exact value (output1) by enabling first row only option, iguess it will work since we are actually filtering folder name from table by select query statement.. explination ???please crt me......
Hi Can someone help me with below error "Failed to convert the value in 'folderPath' property to 'System.String' type." I followed the same steps as like in video but got above error in "Copy Activity". Any help is highly appreciated.
Where exactly the select doldername from....table is getting executed? Meaning in which DB? You created a DS with on existing sql sb right. Help me to understand this point please.❤
Can we use U-SQL activity in place of lookup activity? Because, in both the scenario we are querying on a db and fetching the values. If we can't ? Please share the difference between u-sql and lookup activity?
thats what i am thinking, either he added wrongly in first case( @activity('Lookup')output.firstRow.FoderName) or he missed foldername in second case (@item().foldername) which was wrong ? also doest it require to add .firstRow.FoderName part in dataset parameter value in case 1 , i guess it is already filtering the required folder name from activity output enabling only first row option, so why to hardcode again entire parameter value @activity('Lookup')output.firstRow.FoderName)
For the first requirement you used output.firstRow.FolderName but in the second requirement you used just @item{}. Wouldn't this give the whole row i.e. both the columns? how will it pick just the second column FolderName for each item?
HI maheer , can we use linked credit card for this free subscription ?? i mean i am having two credit cards for icici bank . i have already used one but i cant do it for second , can you assist
Can someone please explain the difference between lookup activity and get metadata activity...Also explain me when we are going to use LookUp activity and Get Metadata activity in realtime, that would really really helpful to me, Thanks in advance!!
In Get meta data activity, it will fetch th data of the file like name,sizez,type ,but in look up activity it will read and retrieve the data present inside the file.. Anyone can correct me if I'm wrong 👍
Metadata works with limited connectors, Lookup has wide variety of connectors and also by default it returns 1 row. I think lookup and copydata activity works hands to hand
hi brother,, doest it require to add .firstRow.FoderName part in dataset parameter value in case 1 , i guess it is already filtering the required folder name from activity output by enabling only first row option, so why to hardcode again entire parameter value with firstrow.FolderName, @activity('Lookup')output.firstRow.FoderName)
it means it cannot just give the exact value (output1) by enabling first row only option, iguess it will work since we are actually filtering folder name from table by select query statement..
explination ???please crt me......
Hi maheer,
Update query in lookup actually updating the table but with failure message.
Can you please suggest any workaround for this.
Thanks
Thank you for super thanks 🤗
hi sir why are u creating datasertt for that db..i think its created right in which the table is their?
Hi Can someone help me with below error "Failed to convert the value in 'folderPath' property to 'System.String' type." I followed the same steps as like in video but got above error in "Copy Activity". Any help is highly appreciated.
Map like this folder=@item().FolderName in the Copy Activity->Sink
@@samsheertc Thanks bro. It helped me 👍
Thank you nice Lecture , if it's possible do with complete scenario we should understand very clearly .
Make sure you create all required prerequisites and execute the pipelines we well.
Where exactly the select doldername from....table is getting executed? Meaning in which DB? You created a DS with on existing sql sb right. Help me to understand this point please.❤
Very helpful video, I was exactly looking for this
Can we use U-SQL activity in place of lookup activity? Because, in both the scenario we are querying on a db and fetching the values.
If we can't ? Please share the difference between u-sql and lookup activity?
What if i need to deal with 10000 record?? Is there any way to push the limit from 5000 to more!!!
Brother you didn't run this after completing. This won't work. You missed foldername parameter in Sink after @item(). It should be @item().foldername
thats what i am thinking, either he added wrongly in first case( @activity('Lookup')output.firstRow.FoderName) or he missed foldername in second case (@item().foldername) which was wrong ?
also doest it require to add .firstRow.FoderName part in dataset parameter value in case 1 , i guess it is already filtering the required folder name from activity output enabling only first row option, so why to hardcode again entire parameter value @activity('Lookup')output.firstRow.FoderName)
Thanks, brother. I tried to execute it but failed with an error. Fixed it by adding the folder value
For the first requirement you used output.firstRow.FolderName but in the second requirement you used just @item{}. Wouldn't this give the whole row i.e. both the columns? how will it pick just the second column FolderName for each item?
in second case its output.value and in copy it will be @item{}.columnn_name
In copy activity sql query we have selected only 1 column ie outputFoldername, so it will take only foldername column from the table.
Your videos are very helpful
Can you make a video on how to use lookup activity for csv files ?
I want to get values from one column of csv file which I have in datalake
HI maheer , can we use linked credit card for this free subscription ?? i mean i am having two credit cards for icici bank . i have already used one but i cant do it for second , can you assist
Thanks for the clear explanation
Welcome
Hi I understand this one....Can you please Explain by connecting to sql server so it makes more sense
can we use the output of look up activity in a SQL of source in copy activity?
Yes
Please provide the links in the description which u have showed in the video
Thank you for feedback. Will do that in upcoming videos
Is it similar to SSIS execute SQL task?
Hi, Can we execute insert SQL like below in Lookup activity.. please let me know.
insert into Table1 (Column1) Select ('test1');
select x;
Lookup is to query and fetch results. Insert isn't possible
God bless you...you are wonderful
Can someone please explain the difference between lookup activity and get metadata activity...Also explain me when we are going to use LookUp activity and Get Metadata activity in realtime, that would really really helpful to me, Thanks in advance!!
In Get meta data activity, it will fetch th data of the file like name,sizez,type ,but in look up activity it will read and retrieve the data present inside the file..
Anyone can correct me if I'm wrong 👍
Hey.. what is the diffrence between lookup activity and get Metadata activity?
Metadata works with limited connectors, Lookup has wide variety of connectors and also by default it returns 1 row. I think lookup and copydata activity works hands to hand
Hi...your putting lot of efforts to make these vide'os..just add 10% more effort to make the lab..so that your channel become to next level (high)
Thanks you!!!!!!
Welcome 🤗
In each video, u tell about user properties :-( add it in title.
we have general, settings and user proprties , if you want to see more about user proprties please check the previous video
@@aqlanable 🤣
Jazakallah Khair for sharing this video :) . I would like to connect with you on this :)