Azure mapping csv Dataset

Matteo Colli 20 Reputation points
2023-02-09T21:05:06.5233333+00:00

Hi all, I need to map a dataset from a csv file, but I have to read it starting from a specific line.

It's possible?

Thank you all

Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,105 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,211 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2023-02-10T17:32:48.7133333+00:00

    Hi Matteo Colli,

    Welcome to Microsoft Q&A Forum and thanks for posting your query.

    My uderstanding is that you are using Copy activity and would like to skip few lines and map rest of the data to your sink. Please let me know if my understanding is incorrect.

    If you would like to read CSV from a specific line in your copy activity, then in copy activity you can use the skipLineCount property in the TextFormat of your dataset. This property allows you to specify the number of rows to skip when reading data from input files.

    89824-image.png

    Ref Doc: Copy activity properties

    User's image

    Hope this info helps.


    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.