Mapping Data Flow adding Headers in Sink Setting bug

Question

1. First of all let me show you the data preview of my source:
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:
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:

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

Answer 1

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 or upvote 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