user406480
user406480

Reputation: 91

ADF Add Header to CSV Sink

Anyone know how to add header to csv sink? I have a data flow that's source is a database table. Then I have used derived column and concatenated the columns to make one column and split the data in the column by commas (done in the source via a query). I have then selected the column that has been concatenated to be export to csv.

Data example:

Matt,Smith,10

Therefore I technically only have one column, however, I want to add a header for each section of the data.

Desired output:

FirstName,LastName,Age
Matt,Smith,10

Upvotes: 0

Views: 1774

Answers (1)

Abhishek Khandave
Abhishek Khandave

Reputation: 3230

You can add headers in CSV file.

Select Data Flow Activity.

Select Source and use Select activity.

Add column names as shown in below screenshot.

enter image description here

Finally add Sink and run Pipeline.

Upvotes: 1

Related Questions