How to remove column header's whitespace/leading spaces

[PassION_es]

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.

[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.

[craigja · Accepted solution]

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

[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 :)