1 Reply Latest reply on Feb 19, 2013 10:51 PM by Robert Morton

    Tableau Query ALIAS Problem

    chandrashekhar vastrad

      SELECT

          test100.name AS none_name_nk

        FROM

          test100

        GROUP BY

          test100.name

       

      In the above query I wanted to remove the " none_name_nk" .

      But i tried with the .tdc with

      <customization name='SQL_COLUMN_ALIAS' value='N' />

       

      Eventhough I am getting the above query with ALIAS AS column name as "test100.name AS none_name_nk"

      Here actually I wanted to remove the ALIAS string "AS none_name_nk" in the query.

       

      Please do needful to solve above problem.

        • 1. Re: Tableau Query ALIAS Problem
          Robert Morton

          Hi Chandrashekhar,

          Tableau will always use aliases for column expressions, and there is currently no way to turn those off. You can however control which characters are considered valid in identifiers by editing the value for SQL_SPECIAL_CHARACTERS in the TDC file you are creating. You can also control how identifiers are quoted by setting SQL_IDENTIFIER_QUOTE_CHAR.

          I hope this helps,

          Robert