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

Question

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.

Answer 1

@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.

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.