blank columns in CSV output file

[Greenlama254]

Hi all, I am trying to create a CSV file in which several columns should remain empty. I created the columns with the Formula tool and fill the cells first with Null, after which I used the Cleanse tool to clear all those cells. In Designer the columns look empty, but when the CSV file is saved to the output folder there are "" in all those cells. Any ideas how to get rid of those "" ?

Thanks in advance

Roger

[DavidSkaife · Accepted solution]

Hi @Greenlama254 

In your Output tool there is a setting for Quote Output Fields, which is set to Auto by default. Simply change this to Never

[Greenlama254]

Thanks a lot David. That indeed did the trick 👍