The Inspire Cyber Monday promo has been extended to Dec. 1! This offer is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Why does Cross Tab substitute underscores for punctuation characters, even for blanks.

8 - Asteroid

I have two columns, one is Name, another is Value.


Loan Cross Ref12345678


When it is transformed by Cross Tab, the field names based on the Name changed to be "Loan_Cross_Ref", by adding this underscore between each word. This is annoying as it always failed in the Join tool following since the field in another file is coming as Loan Cross Ref.


So I am trying to understand the design logic of adding this underscore. As for temp solution, I have to use a select tool right after the Cross Tab to rename the field.

20 - Arcturus
20 - Arcturus

Hopefully Alteryx can help all of us out and this can be enhanced. 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
20 - Arcturus
20 - Arcturus

It seems this is not a "bug", rather than a compromising between speed and formatting.

Go to above link and find below paragraph for the explaination and workaround. ‌‌

Pro Tip: Renaming Fields

A downside of the Cross Tab tool is that it doesn't play nice with special characters in field headers, including spaces. This means that if you have a field header "a a", it will actually come out as "a_a". I know this can be a bit inconvenient, but when we were developing the Alteryx engine we prioritized speed and efficiency over keeping the field headers looking nice. Don't worry though - there's a perfectly doable solution to this problem (more than one actually! ) that makes use of an awesome tool called Dynamic Rename . This is the way I usually like to go about it:

7 - Meteor

it does seem like a bug