Cross Tab Tool - Losing Original Formatting in Column Header

[joe_de_foleschampe]

Hi, I am working with a large time-series, when I am ready to flip my results after some calculations, from vertical to horizontal so time runs left to right, when I use the Cross Tab Tool, I lose original formatting in the Column Header.

So, when working prior to using the Cross Tab Tool, my time-series is running vertically so time runs top to bottom with a YYYY.Q format that I need for later in the output process to Excel and then charting with this format.

When I use the Cross Tab Tool and flip obtain the following in the Results...I lose the YYYY.Q formatting:

...and also, obviously, in the Excel output though an Output Tool:

Not sure why this happens and I have played with the Type of YYYY.Q column in a Select Tool no avail. Am I missing something in a configuration setting?

Thanks for any insight/help!

[Thableaus · Accepted solution]

Hi @joe_de_foleschampe 

All non-word characters are transformed into underscores (_) when using Cross-Tab Tool.

This is a normal behavior.

A workaround would be using the Dynamic Rename Tool.

In your case, it should be very simple. Use Formula method.

ReplaceChar([_CurrentField_], "_", ".")

Cheers,

[joe_de_foleschampe]

Excellent! Thank you again for your guidance!