#67. Azure Data Factory - Load data from multiple XL sheets to Azure SQL table

In real time, data comes in many sheets in XL file. ADF makes it simpler to process any number of sheets with ease, This video explains the steps required to process different sheets one by one and to load into azure SQL table. Do watch and provide your comments.

[oriono]

Thanks for explaining in an easy way...

[phaneendraeluru]

should we create any table in database before selecting our sink as database

[Van-pfor]

Is there an option to get the Sheet Index or names from a Excel file dynamically? I looking for something where i dont specify the hardcoded sheets names in the variables, instead it should pick from the Workbook

[Bloody_August]

Great video! Do you have video maam to ingest xlsx with two sheets and convert it to single csv file? That is blob to blob

[PinkiG]

Hi, Is there a way to load data from same excel automatically to SQL server DB using ADF?

[absspaceinformation]

Hello, How to copy data from azure sql server (data that I can get by running the sql query) to excel sheet that is located on Azure datalakes.

[muralikrishna]

mam ...
where we have to mention the range if each sheet has different range values

[SiriVlogs-wd]

Hi, Can you make a video on how to load data from multiple excel sheets with different tabs in each sheet with the same name for multiple excel sheets.

[seetharamireddy]

I have one doubt let assume i have 1TB data in MySQL db. . I want to move the data from MySQL to adl's . its taking 15min(assume ) . so I want optimize the time . can you please do one video on optimization techniques

[manikantareddy]

Can u pls explaine multiple xls files

[senorgato]

Hi, thanks very much for your videos. I have a question, maybe you know how do it. Do you know Qlikview? QV have a function called mapping. for example the tabla A have field personal_code, name, lastname and the table B hace personal_code, country. Using QV Mapping, I can get the country passing the personal_code. Is similar a joing.

In Datfactory, exist the posibility to create a deribed column passing a value and getting the value from a table?

Thanks so much.

[saiharispeakztech]

Nice. It looks simple. But challenge would be to write to a text file.

[manikantareddy]

Multiple xls with multiple sheets pls do one video on it

[kumaronchat]

Could you please show us on the mapping columns? I have the same scenario but with column names and position
are different in each sheet. Or could you please show me where i can find document for this?
Thanks in advance.

[insane]

Ive questions like it's multiple sheets then in source dataset why do provide file name here

[RahulPatil-nihk]

Nice video. It would be helpful if you do video on
How we can give dynamic table name based on sheet name

[shivanidubey]

How we can give dynamic table name based on sheet name