25. Hands-On : Iterate over excel file sheets dynamically and copy them as a CSV file|| Step-By-Step

know about trainer goo.gl/maps/9j...
Contact us [e-mail]
whats app [phone]
For More details visit www.cloudpandith.com
Q1). A
Q2). C
Q3). C
Q4). C
Q5). B
Q6). C
Azure Data Factory Master Program Video Links
1. Introduction to Azure Data Factory
• 1. Introduction to Azu...
2. Key features of Azure Data Factory
• 2. Key features of Azu...
3.Why Azure Data Factory with Real Time Scenario || Functional Scenarios || Technical Scenarios
• 3.Why Azure Data Facto...
4. How to Create Azure Free Account Today|| Troubleshoot if you can't create a free account in azure
• 4. How to Create Azure...
5. Login into Azure Portal || Introduction to Azure Portal || Azure Portal Walk Through
• 5. Login into Azure Po...
6. Create your First Azure Data Factory || create azure data factory step by step || Prerequisites
• 6. Create your First A...
7. Automate Azure Data Factory Creation using Databricks Python Notebook || Create ADF with Python
• 7. Automate Azure Data...
8. Create and Delete Azure Data Factory using Powershell || Powershell Variables || Cloud Shell
• 8. Create and Delete A...
9. Data Engineering with Azure: Deep Dive into Data Factory's Top-Level Concepts and Main Components
• 9. Data Engineering wi...
10. Mastering Azure Blob Storage: Step-by-Step Tutorial for Developers || Advanced Tutorial for Blob
• 10. Mastering Azure Bl...
11. Mastering Azure Blob Storage : Step-by-Step Create Storage account & Container and Data Upload
• 11. Mastering Azure Bl...
12. Azure Blob Storage | Azure Storage Services | Blob Types | Block Blob | Page Blob | Append Blob
• 12. Azure Blob Storage...
13. What is Integration runtime in azure data factory and Types of Integration Runtime with Usecases
• 13. What is Integratio...
14. Deep dive into Linked Service in Azure Data Factory || Category of Linked Services in ADF
• 14. Deep dive into Lin...
15. Deep dive into Datasets in Azure Data Factory || Category of Datasets in ADF
• 15. Deep dive into Dat...
16. Hands-On : How to Copy Data from Source Blob to Sink Blob using 15 steps in ADF || Step-By-Step
• 16. Hands-On : How to ...
17. Hands-On : How to Copy Data from Source Blob to Sink Blob with Dataset Parameters|| Step-By-Step
• 17. Hands-On : How to ...
18. Hands-On : How to Copy Data with Pattern Matching Wildcard filepaths from Blob to Blob || Step-By-Step
• 18. Hands-On : How to ...
19. Hands-On : unzipping in adf | Unzip .zip .gz files using Copy activity in ADF || Optimal vs Fastest || Step-By-Step
• 19. Hands-On : Unzip ....
20. Hands-On : Extract zip/gz files in Azure Data Factory using Copy activity | Step-by-step || Labs
• 20. Hands-On : Extract...
21. Hands-On : How to convert CSV to Parquet in Azure Data Factory || Data Ingestion in ADF || Step-By-Step
• 21. Hands-On : How to ...
22. Hands-On : How to convert Parquet to CSV in Azure Data Factory || Data Ingestion|| Step-By-Step
• 22. Hands-On : How to ...
23. Hands-On : Transforming Custom Delimited CSV to Parquet from Blob Storage using ADF || Step-By-Step
• 23. Hands-On : Transfo...
24. Hands-On : Transforming Custom Delimited CSV to JSON from Blob Storage using ADF || Step-By-Step
• 24. Hands-On : Transfo...
25. Hands-On : Iterate over excel file sheets dynamically and copy them as a CSV file|| Step-By-Step
• 25. Hands-On : Iterate...

[@swapnikavanabathina1532]

Is we have empty header columns in few tabs. How to handle it dynamically?

[@Sitaram-ek3cc]

How to handle the same scenario but multiple Excel workbooks with multiple sheets (but sheet1, sheet2.. sheetN schema is the same all workbooks). But want to merge sheet1 data from all workbooks to CSV and the same with the rest of the sheets. Please let me know - thanks
Example:
workbook1 name - India (sheet1 - batters, sheet2 - bowlers, sheet3 - coaching staff)
workbook2 name - Australia (sheet1 - batters, sheet2 - bowlers, sheet3 - coaching staff)
.
.
workbook5 name - New Zealand (sheet1 - batters, sheet2 - bowlers, sheet3 - coaching staff)
Output:
Batters.csv -> Workbook1.sheet1 + Workbook1.sheet1 + .... + Workbook5.sheet1
Bowlers.csv -> Workbook1.sheet2 + Workbook1.sheet2 + .... + Workbook5.sheet2
Coaching Staff.csv -> Workbook1.sheet3 + Workbook1.sheet3 + .... + Workbook5.sheet3

[@SuprajaBijjigiri-o4s]

If you got the answer please let me know

[@rakshitha.kokkula6363]

How to get dynamically sheet names in the array instead of giving sheet names?

[@SantoshKumar-yr2md]

if we have more than two sheets, N number of sheet then @createArray('Emp', 'Training') will it work as you showing in recording, how will pass every sheet name

[@siataylor7204]

How do we do this if we do not know the sheetname and it changes for every instance

[@aslamnaturalfarming2128]

If customer placed more files, how event based trigger will work?
Please post video. Thanks for your video

[@Cloudpandith]

That is called multi dependency trigger file. In such cases we need to use audio table and check run status for today if it is already ran for today based on first all subsequent runs pipeline should skip
Other way is we can use schedule trigger instead of event based and check whether latest files loaded in folder if you find latest files in folder then you start your process else wait using wait activity and keep checking for 15mins etc..there are lot of ways to discuss. We have live webinar sessions which you can attend to clarify them

[@aslamnaturalfarming2128]

@@Cloudpandith how to connect with you. Are you providing session?
Thanks

[@Cloudpandith]

@@aslamnaturalfarming2128 current workshop is closed

[@Cloudpandith]

@@aslamnaturalfarming2128you can check our website www.cloudpandith.com to get more details

[@aslamnaturalfarming2128]

@@Cloudpandith thank you