Whenever I use cross tab, no matter what field I select for the "Change column headers" option, the name of the new columns isn't exactly the same as the value that was inside those cells.
All spaces, dots, hyphens and basically every symbol are replaced by underscores in the new columns created. This shouldn't happen, but anyway, I say let's just use a dynamic rename and fix them. But then again, you can't fix them with the dynamic rename tool either, because the underscores were sometimes dots, sometimes spaces, sometimes another symbol, so there's no regex rule you can use to differentiate. So I have to use a formula and replace spaces with a placeholder character and dots with a different placeholder character before the crosstab just so I can use a dynamic rename and fix the column names after the cross tab because cross tab isn't renaming columns correctly and replaces characters with underscores? This seems backwards. I have like 100+ different values that are being cross tabbed into columns and I need the name translation to be exact in order to be able to integrate this with my other workflows.
