Custom Header for a CSV file
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.
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.
