Retain special characters in crosstab column names

[kelly_gilbert]

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!

Special characters renamed in crosstab.yxmd

[jacob_kahn]

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

thanks for this idea. Totally agree

[KylieF]

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.

[lailas]

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

[SriKoka]

Yes please.. 

[mceleavey]

Seconded.

[kwon23]

Just curious, was anyone able to figure this out?  I am still trying to find a way to keep the headers as is when using the cross tab tool.  Or does anyone have any suggestions about a work around? 

Thanks, 

[patrick_digan]

This would be a nice little add!

[Kenda]

This is definitely necessary! It's silly to have to build a workaround each time this tool is used.

[Carlithian]

Would love this