Multiple header rows for output

[dho111]

Hi,

I would like add multiple lines header to a dataset and create a .csv file. Is there anyway I can avoid the extra comma in the header when creating the file?

[jamielaird · Accepted solution]

The CSV represents the full 8x6 grid and even though the cells are null they do still exist so I'm not sure what you're trying to achieve is possible.

If you're looking to produce a block of text then yes you could absolutely do this in a way that doesn't include superfluous commas.

[mmenth · Accepted solution]

Hi @dho111 ,

I'm not sure exactly what you want to do with this, but you could insert an extra comma into your fields, then change your delimiter to a space in your output tool. You'll have a lot of extra whitespace after you headings, and those headings will still align with the first column, but depending on what you do next with the file maybe this will help by essentially giving you the option to work with two delimiters.

Best,

mmenth

[dho111]

Thanks guys! That's exactly what I need to know.