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

Question

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

Answer 1

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