How to handle an excel sheet(only 1 tab) with multiple datasets with different columns and ranges

Spandana Mogadala 0

Hi Team,

Could you help me out with below Scenario of ADF?

I have a single Excel file with just one tab, as displayed below with different columns and that tab contains 2 datasets. We want to move this data to 2 different SQL tables using ADF/data flow.

User's image

1 answer

Nandan Hegde 32,336 Reputation points MVP

2024-07-24T13:11:18.7466667+00:00

Excel dataset has a range property that helps you define the range from which you need to copy the data

https://stackoverflow.com/questions/70786748/azure-data-factory-import-excel-file-with-dynamic-range2

https://learn.microsoft.com/en-us/azure/data-factory/format-excel
Please sign in to rate this answer.
Spandana Mogadala 0 Reputation points

2024-07-24T13:40:49.71+00:00

Thank you for your response. I can’t specify the fixed range in my case because we might get different set of rows for each day.

Nandan Hegde 32,336 Reputation points MVP

2024-07-24T13:55:41.3333333+00:00

If that is the case, then you would have to write a custom code to scan across the rows to determine the start range and the end range.

unfortunately ADF doesnt support that

Spandana Mogadala 0 Reputation points

2024-07-25T06:26:30.5166667+00:00

Need to find a solution for this
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to handle an excel sheet(only 1 tab) with multiple datasets with different columns and ranges

1 answer

Your answer