How to Divide data into multiple outputs by using Conditional Split Transformation in ADF | 2022

How to Divide data into multiple outputs by using Conditional Split Transformation in Azure Data Factory | ADF Tutorial 2022, in this video we are going to learn How to Divide data into multiple outputs by using Conditional Split Transformation in Azure Data Factory | 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 Divide data into multiple outputs in Azure Data factory by using Conditional Split Transformation TotalSale.csv id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region 8,Aleena,Aman,Laptop,2,800,5/25/2015,Lahore,Punjab,Pakistan,Asia 5,Najaf,Ali,Computer,1,300,6/20/2015,Karachi,Sindh,Pakistan,Asia 6,Sukhjeet,Singh,TV,2,900,6/21/2015,ChandiGar,Punjab,India,Asia 7,Chirag,Patel,Cell Phone,5,1500,6/23/2015,AhmadAbad,Gujrat,India,Asia 1,Aamir,Shahzad,TV,1,700,7/15/2015,Charlotte,NC,USA,North America 2,M,Raza,Cell Phone,2,800,7/15/2015,Charlotte,NC,USA,North America 11,Tamara,Tony,Cell Phone,2,1200,3/3/2015,Frankfurt,Hesse,Germany,Europe 10,Rita,Roger,Laptop,7,2100,4/11/2015,Paris,Île-de-France,France,Europe 9,Petra,Henry,TV,10,5000,4/8/2015,Paris,Île-de-France,France,Europe 3,Christy,Ladson,TV,3,1600,4/2/2015,High Point,NC,USA,North America 4,John,Rivers,Laptop,5,2400,3/9/2014,Jersey City,NJ,USA,North America 4,John,Rivers,Laptop,5,2400,3/9/2014,Jersey City,NJ,USA,Africa SQL Tables for Demo CREATE TABLE [dbo].[TotalSale] ( [id] [int] not null ,[SalePersonFName] [varchar](100) NOT NULL ,[SalePersonLName] [varchar](100) NOT 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) ) CREATE TABLE [dbo].[TotalSaleAsia] ( [id] [int] not null ,[SalePersonFName] [varchar](100) NOT NULL ,[SalePersonLName] [varchar](100) NOT 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) ) CREATE TABLE [dbo].[TotalSaleEurope] ( [id] [int] not null ,[SalePersonFName] [varchar](100) NOT NULL ,[SalePersonLName] [varchar](100) NOT 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) ) CREATE TABLE [dbo].[TotalSaleNorthAmerica] ( [id] [int] not null ,[SalePersonFName] [varchar](100) NOT NULL ,[SalePersonLName] [varchar](100) NOT 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) ) Select * from [dbo].[TotalSale] Select * from [dbo].[TotalSaleAsia] Select * from [dbo].[TotalSaleEurope] Select * from [dbo].[TotalSaleNorthAmerica] 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