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

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

    jim.forsythe

      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):

       

      ACCOUNT_NUMBER

       

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

       

      Any help would be appreciated.