how to keep trailing space in column headers?

Question

Hi, alteryx is dropping any spaces at the end of the column header while writing the output. Can this be avoided please?For example Header (7 chars) is becoming just header(6 chars)i can see the trailing spaces till the last tool before output. But in excel the space gets removed. - output is an overwrite sheet - excel(xlsx)

cjaneczko · Answer

Do the columns stay in the same order and location after each overwrite? Can you skip the column headers and just output the data starting at the row below the headers? In the output options you have the ability to skip the header output. This would solve the problem if all of your fields are in the same location after each output. Set the formatting of the headers in Excel and they wont be overwritten after each workflow run.