cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Header for a CSV file

Senthilnaga91
New Contributor II

Hello All,

I am looking for an approach to add a custom header before writing into a CSV file. I have referred the below link and developed one, but the issue is double quotes appended at the start and end of the content. So, when I open the CSV file in excel, all the content gets accumulated in a single cell instead of in a different row and columns. Please refer the screen shot below.

Please help me to sort out this.

Reference Link
Adding header and footer - Designing Pipelines / Solutions - SnapLogic Community

image
image

Double quotes appended at start and end of the document

image

When you open the CSV in Excel

image

Expected CSV output.
image

1 ACCEPTED SOLUTION

Senthilnaga91
New Contributor II

The issue is sorted by removing the CSV formatter at the end and change the mapper output view to binary and connected the file writer directly.

View solution in original post

1 REPLY 1

Senthilnaga91
New Contributor II

The issue is sorted by removing the CSV formatter at the end and change the mapper output view to binary and connected the file writer directly.