Custom Header for a CSV file

[Senthilnaga91]

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

Double quotes appended at start and end of the document

When you open the CSV in Excel

Expected CSV output.

[Senthilnaga91 · Accepted solution]

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.