Awesome bro - I got the exact question from one interview where I mentioned the same case with azure functions + fpreach copy but this is more informative but for failed activity part.
Hello @WafaStudies: I do have scenario, in which I need to work with Excel of 250MB of size( multiple Sheets in it) Currently, the copy activity takes a lot of time, can you suggest in this case?
Hello do we have anyway to create json files for all documents available in cosmos mongo db api? I need to migrate data from cosmos mongo to google postgres any good way to achieve this?
Yes Hi Maheer you we may need to find some different logic because if some other error occurs inside until activity you will not able to find or log.Anyway attempt was good and got learn alot all the best thanks for sharing.
Hi bro, I have one doubt is this logic applicable to multiple excel files with multiple sheets to generate a csv file, could u please clarify my doubts
@@Sitaram-ek3ccin our we used Metadata configuration in that we have to mention sheet sheetnames in configuration then it will generate each sheet as csv
Hi Anna from Kadapa. Your Videos awesome. How to copy each sheet at scheduled time. Example: I want to copy sheet 2 after 1 hour. Pls let me know if you have answer
Hi sir, I hope you're having a wonderful day. I have csv file with 3 columns ID Name Gender 1 Raja Male 2 Sara Female 3 Aksha Male 4 Ritu Female But i just want to read Female gender record and send to sink location Output: ID Name Gender 2 Sara Female 4 Ritu Female Can we achieve this in using Azure data factory?
Excellent work bro. Thanks!
Thank you
Awesome bro - I got the exact question from one interview where I mentioned the same case with azure functions + fpreach copy but this is more informative but for failed activity part.
Awesome explanation..great efforts..👏👏
Nice explanation bro 👍 👌 👏
Thank you ☺️
nice work done by you
Hi..if I want the name of the sheet in the filename.csv then what should I do
What if there is any other error in copy activity
Good Effort sir
Thank you 😊
I need all the output CSV files in single sheet one row below other, here the column header is same. could you please give me the solution for this
great, I also encountered exact question
Hello @WafaStudies: I do have scenario, in which I need to work with Excel of 250MB of size( multiple Sheets in it)
Currently, the copy activity takes a lot of time, can you suggest in this case?
Wafa, how can do That with data flow and apply a transformation to any sheet?
@WafaStudies
Hi Dude,
Where I can meet you?
Hello do we have anyway to create json files for all documents available in cosmos mongo db api? I need to migrate data from cosmos mongo to google postgres any good way to achieve this?
Sir my humble request please make video on microsoft interview process for azure data engineer role
Is any direct way to convert from azure SQL tablets into Excel sheet.
Great job mate
what if you want your pipeline to fail when legitimate errors occur?? this is such bad code
Yes Hi Maheer you we may need to find some different logic because if some other error occurs inside until activity you will not able to find or log.Anyway attempt was good and got learn alot all the best thanks for sharing.
Hi bro, I have one doubt is this logic applicable to multiple excel files with multiple sheets to generate a csv file, could u please clarify my doubts
@sravankumar1767 - Did you get the answer to your question? multiple excel files with multiple sheets to generate a csv file? if so pls share here
@@Sitaram-ek3ccin our we used Metadata configuration in that we have to mention sheet sheetnames in configuration then it will generate each sheet as csv
Hi Anna from Kadapa. Your Videos awesome. How to copy each sheet at scheduled time. Example: I want to copy sheet 2 after 1 hour. Pls let me know if you have answer
You can schedule the Trigger accordingly
Hi sir,
I hope you're having a wonderful day.
I have csv file with 3 columns
ID Name Gender
1 Raja Male
2 Sara Female
3 Aksha Male
4 Ritu Female
But i just want to read Female gender record and send to sink location
Output:
ID Name Gender
2 Sara Female
4 Ritu Female
Can we achieve this in using Azure data factory?
We can use Adf Dataflows filter transformation to filter Female records.