CSV output headers not in 1 row but instead appears as 2 rows.

Hi. I have an issue when I am trying to output csv file. For whatever reason the headers are coming out in 2 rows instead of 1 (Please refer to csv file attached).
I don't understand the cause of this. Can someone help me here?

Also to note the data is coming out fine. It is just the headers that are being messed up.

Please find attached screenshot of my CSV output file settings.
For context also, I have 4 csv output files. But 2 of them are coming out with headers like this and for another 2 the headers are being displayed just fine.

Thanks!

7_monthly_Global Purchases Journal_ sample headers.csv

Screenshot 2025-08-08 155309.png

Developer

Output

Accepted answers

Gaurav_Dhama_

So here is the culprit, column name "Income Currency Code" has new line at the end of it. That is why you are seeing headers breaking into two rows. See the snip below.

To fix this, you can just add a dynamic rename and use trim.

Attached is the workflow.

sample workflow 1.yxmd

All comments

unknown

@Apizzacake in your workflow do the headers appear in two rows? If yes then the output will come the same way.

Apizzacake

Hi, no it does not appear in 2 rows, this is the select tool just before the csv output.

Raj

@Apizzacake can you share workflow with sample data
will try to help

Gaurav_Dhama_

two questions:

1. How are you taking the output? is it single Output Data tool with fixed path or any other method?

2. Is the screenshot in reply is of the file that spilled the headers to 2 rows?

Apizzacake

hi, Gaurav. it is a single output csv file but I appended the file path to match an output folder that I want the file to go to.

Yes the screenshot in reply is that of the file that split the headers to 2 rows.

Upon further inspection under the csv output file. When i set quote output files to auto. This appears. Currently I require the file to never quote output fields.

To solve, i basically renamed this header to be the same. And now it is working fine

Attached is my workflow showing 2 outputs of quoted and unquoted coming out differently. Is it possible that it is due to the renaming of the header being wrong?

sample workflow 1.yxmd

Gaurav_Dhama_

So here is the culprit, column name "Income Currency Code" has new line at the end of it. That is why you are seeing headers breaking into two rows. See the snip below.

To fix this, you can just add a dynamic rename and use trim.

Attached is the workflow.

sample workflow 1.yxmd

Apizzacake

thanks this works

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703