Azure data factory - Add one row above column header in. Csv/txt

Pankaj Joshi 286 Reputation points
2023-03-31T16:30:50.9966667+00:00

I have to add one row above column header in Csv/txt file. Csv file contain column and data as col1, col2, col3 with row data as 1,2,3 4,9,1. Now I want one to add one label "snapshot date: 2023-03-31" above col1, col2, col3. How it can be achieve through copy activity or dataflow. How I can insert new line before column header? Please share any details or link.

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

Accepted answer
  1. AnnuKumari-MSFT 31,716 Reputation points Microsoft Employee
    2023-04-03T08:44:13.8166667+00:00

    @Anonymous ,

    Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

    Glad to know that you were able to resolve the issue by yourself.

    As rightly mentioned by you, you can use the "Headers" option in Sink settings to add the header or title above the column names in your dataset.

    User's image

    You can check out the following video for the implementation: How to add header or title above column names in file using mapping dataflow


    Kindly accept the answer if this is the approach you have followed to achieve the requirement. Thankyou.

    0 comments No comments

0 additional answers

Sort by: Most helpful