Keep leading spaces in the column names in excel output

Hi all,

In the excel output I need to keep leading spaces in the column names (so I can use as template in other system which requires specific column names including all whitespaces).

Do you know how to keep all whitespaces in column names ? Renaming columns in the select tool didn't help.

Thank you!

Asia

Output

Accepted answers

patrick_digan

@joannasokolowska can you use ascii character 160? It looks the same to the eye, but I'm not sure if it will work for you.

excel spaces.yxmd

All comments

messi007

@joannasokolowska,

Could you share a sample data, Alteryx will read the column as it come from Excel.

As you can see below I have 2 first column contains white spaces 🙂

Regards,

joannasokolowska

Hey,

Thank you for a quick response. The thing is that that in input data it is without whitespaces but I want to add it into the output excel file.

On your prtscreen I see that the outcome from select tool includes leading spaces (the same in my workflow) but if you save it as excel, and open in excel you will not see them there.

Best,

Asia

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703