Anyone know how to add 2 spaces in a column name when using Table Tool to generate a repor

Hello! I am trying to add two extra spaces at the end of a column header (for ex: "Name "). When I try to accomplish this, it won't let me. I am generating the report using Table tool. I see that one extra space is added in all field names in the output but additional spacing doesn't seem to get translated into the output.

Has anyone experienced similar issues? Any ways to add extra spacing in the column header when using report tool?

Thank you!!!!

Common Use Cases

Preparation

Accepted answers

kathleenmonks

Hi @kkkim,

This community article can assist in adding the spaces - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Keep-Leading-Whitespace-in-Table-Tool-Output/td-p/140685

In the table tool, you can rename your column names. Instead of entering spaces after "Name" hold down the alt key and type 255 (use the numeric keypad and not the keyboard) then release the alt key and you'll have one space. Do this again and you'll have two spaces that will appear in the resulting table.

Note that you can also use the technique above in a dynamic rename tool before the table tool to have it affect multiple columns at a time and not have to rename them individually in the table tool.

Let me know if this helps!

All comments

kathleenmonks

Hi @kkkim,

This community article can assist in adding the spaces - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Keep-Leading-Whitespace-in-Table-Tool-Output/td-p/140685

Note that you can also use the technique above in a dynamic rename tool before the table tool to have it affect multiple columns at a time and not have to rename them individually in the table tool.

Let me know if this helps!

FilipR

@kkkim You can always try adding non-breaking spaces instead of regular ones.

https://www.compart.com/en/unicode/U+00A0#:~:text=%E2%80%9C%20%E2%80%9D%20U%2B00A0%20No%2D,Break%20Space%20(NBSP)%20Unicode%20Character

kkkim

Thank you so much for this!!!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703