4 Replies Latest reply on Aug 6, 2014 1:11 PM by kettan

    Connect data removes "_" from column names (Tableau 8.2)


      When I connect to data in Tableau 8.2, when I connect to a table it removes all "_" in my column names and will undo Cap letters.


      If I do a custom sql query, it does not change the columns.  When I use a normal data connection and a custom sql connection I have to do edit relationships anytime I want to create a common field.


      Is there a way to avoid this, my tables I am connecting to have 1K+ columns, so manually changing is out of the question.


      Example of Dimension from Standard data connection is:


      Account Number


      Example of Dimension from Custom sql query (which matches the source file):




      I am sure how many of you can see how this would get annoying.


      Any help would be appreciated.