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!
Solved! Go to Solution.
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,