Azure Data Factory: Skip first 2 rows and use 3rd row as header

Biswajeet Pruseth 21 Reputation points
2021-07-08T06:08:54.387+00:00

Hello,

I need to copy data from a csv file to Data Warehouse where I need to skip the 1st 2 lines and use the 3rd row as header and copy rest of the data.

I have a text file that looks something like this-

Row1
Row2
HEADER
Row4
Row5
.
.
.
RowN

The data in Azure Data Warehouse should look like -

HEADER
Row4
Row5
.
.
.
RowN

What would be the best way to do this?

Thanks,
Biswajeet Pruseth

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,462 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,561 Reputation points
    2021-07-08T08:04:16.627+00:00

    In the dataset for CSV file, Set first row as header and in the Source add 2 in Skip line count box

    Use below just for reference :

    https://learn.microsoft.com/en-us/answers/questions/365211/azure-data-factory-skipping-2nd-amp-3rd-rows-from.html

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful