How to Load Multiple Excel Files with Different Sheet Name to Azure SQL Table in Mapping Data Flow

How to Load Multiple Excel Files with Different Sheet Name to Azure SQL Table in Mapping Data Flow - ADF Tutorial 2022, in this video we are going to learn How to Load Multiple Excel Files with Different Sheet Name to Azure SQL Table in Mapping Data Flow - ADF Tutorial 2022, Azure Data Factory Step by Step - ADF Tutorial 2022 - ADF Tutorial 2022 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2022

Script:
How to Load Multiple Excel Files with Different Sheet Name to Azure SQL Table by using Mapping Data Flow in Azure Data Factory
TotalSale create table definition
CREATE TABLE [dbo].[TotalSale](
[id] [int] NULL,
[SalePersonFName] [varchar](100) NULL,
[SalePersonLName] [varchar](100) NULL,
[ProductName] [varchar](100) NULL,
[ItemsSold] [int] NULL,
[SoldPrice] [float] NULL,
[SoldDate] [date] NULL,
[City] [varchar](100) NULL,
[State] [varchar](100) NULL,
[Country] [varchar](100) NULL,
[Region] [varchar](100) NULL,
[FileName] [varchar](100) NULL
)

TotalSale_Asia data
id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region
5,Najaf,Ali,Computer,1,300,2015-06-20,Karachi,Sindh,Pakistan,Asia
6,Sukhjeet,Singh,TV,2,900,2015-06-21,ChandiGar,Punjab,India,Asia
7,Chirag,Patel,Cell Phone,5,1500,2015-06-23,AhmadAbad,Gujrat,India,Asia
8,Aleena,Aman,Laptop,2,800,2015-05-25,Lahore,Punjab,Pakistan,Asia

TotalSale_Europe data
id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region
9,Petra,Henry,TV,10,5000,2015-04-08,Paris,Île-de-France,France,Europe
10,Rita,Roger,Laptop,7,2100,2015-04-11,Paris,Île-de-France,France,Europe
11,Tamara,Tony,Cell Phone,2,1200,2015-03-03,Frankfurt,Hesse,Germany,Europe

TotalSale_NorthAmerica data
id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region
1,Aamir,Shahzad,TV,1,700,2015-07-15,Charlotte,NC,USA,North America
2,M,Raza,Cell Phone,2,800,2015-07-15,Charlotte,NC,USA,North America
3,Christy,Ladson,TV,3,1600,2015-04-02,High Point,NC,USA,North America
4,John,Rivers,Laptop,5,2400,2014-03-09,Jersey City,NJ,USA,North America

Azure Data Factory Tutorial for beginners
Azure Data Factory Tutorial 2022
Step by step Azure Data Factory Tutorial
Real-time Azure Data Factory Tutorial
Scenario-based training on Azure Data Factory
Best ADF Tutorial on youtube

#AzureDataFactory #ADFTutorial2022

[MattDonnelly-xgbz]

Another great tutorial. I found this easy to follow. Thanks for posting,

[nadeemrajabali]

Great tutorial. I have around 12 files but few files have one extra column that I want to exclude. Is it possible using this approach?

[villageroyalfriends]

Thank you sir such a woder full tutorial and also post Databricks and pyspark

[Sitaram-ekcc]

Thanks for the content. Please make a video or explain How to Load Multiple Excel Files with multiple Sheets to CSV?
Each workbook sheet structure is the same; here is an example. thanks in advance.

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

[parulgupta]

Can we load data from staging table to a csv Or day file?

[Jetcodelab]

What if u have several sheets and want to copy all