Mapping Data Flow adding Headers in Sink Setting bug

Shubham Phegade 21 Reputation points
  1. First of all let me show you the data preview of my source: 248600-image.png
  2. In the Sink setting there is an option to add headers so, by using that I want to replace col0 with 'id' , col1 with
    'name' and so on..
  3. In the expression we have to provide the array of strings which I have provided as below: 248626-image.png
  4. But the when I see the output file in blob storage, the array content is coming as a new line rows and Col1 , Col2, .. is not replaced by the provided column names. Please refer the below output: 248627-image.png

Please provide a solution on this and correct your logic if it is implemented incorrectly.

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

Accepted answer
  1. ShaktiSingh-MSFT 14,076 Reputation points Microsoft Employee

    Hi @Anonymous ,

    Welcome to Microsoft Q&A platform and thanks for using Azure Services,

    As I understand the question, you want to add column headers to your incoming data. You are using Headers option in Settings section of Sink configuration which is not serving the purpose.

    To accomplish this, I would suggest you disable Auto mapping in Sink's Mapping tab and then name Output columns as column header name:


    Current Headers option settings will create a header on top of the output file. It is not configured to add provided header values to incoming columns.

    Hope this will help. Please let us know if any further queries.


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    2 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful