This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 56.00000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
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.
Excel dataset has a range property that helps you define the range from which you need to copy the data
https://learn.microsoft.com/en-us/azure/data-factory/format-excel
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.
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
Need to find a solution for this