ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Retain special characters in crosstab column names

The crosstab tool replaces any non-alphanumeric characters with underscores in column names. It would be helpful to keep the original values as column names (or to have the option to toggle whether or not special characters are replaced with underscores).


This is often an issue for reporting and for dynamically-populated app inputs (e.g. drop-down), where we need to retain the special characters.


For example, say I have the following dataset: 



Currently, the crosstab tool produces this:



I would like this:



There are currently (somewhat cumbersome) workarounds such as adding an extra row with the original names, and then using Dynamic Rename to rename the columns, but it would be great to be able to use the data straight out of the crosstab!

12 - Quasar

This is such a stressful thing with using the Cross Tab tool!


thanks for this idea. Totally agree

Alteryx Community Team
Alteryx Community Team

Hello! Thank you for your feedback! If you haven't yet, be sure to look over our Submission Guidelines which go over the idea boards process in a bit better detail. However your idea overall looks good to go once the necessary criteria have been met.

7 - Meteor

this is really necessary addition!!! please incldue!!!

7 - Meteor

Yes please..