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
