How to remove column header's whitespace/leading spaces

Hi Alteryx Community,

How to remove field names' whitespaces or leading spaces or special characters?

I used the transpose tool and cleanse tool but I was not able to reverse the way it was originally arranged using cross tab tool. I think I might still be figuring out how to use the Cross Tab tool.

Example: One data set has these field names:

Active*

Cancelled_Status

Company (with leading spaces)

Thank you in advance.

Tips and Tricks

Transformation

Accepted answers

craigja

Use the Dynamic Rename function, set Rename Mode to Formula and then in the Expression section, use this: replace([_CurrentField_], ' ', '') to replace any spaces

Screenshot 2024-09-27 132429.png

All comments

JosephSerpis

Hi @PassION_es you can use the dynamic rename tool in Alteryx Designer if you hover over the tool in the Developer category it has some examples you can click to review how to setup.

Screenshot 2024-09-27 132541.png

craigja

Use the Dynamic Rename function, set Rename Mode to Formula and then in the Expression section, use this: replace([_CurrentField_], ' ', '') to replace any spaces

Screenshot 2024-09-27 132429.png

alexnajm

Either clean them before the Crosstab with a Formula tool, or clean them with a Trim function in the Dynamic Rename tool after the Crosstab!

PassION_es

Thanks all

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703