Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,990 questions
Hey
You can use range function in excel dataset to skip the initial lines
Unable to Skip a line in Excel dataset in Azure data factory
![](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(166.4, 42%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sampath S
81
Reputation points
Input :Excel dataset Sheet ,Sheet Number 1
Output:Azure Sql table
I want to skip First 5 lines and map my remaining columns to sql Table.
How can I do that?
PS: I am using copydata activity
Accepted answer
-
Nandan Hegde 32,831 Reputation points MVP2022-10-15T13:28:02.357+00:00