7 Replies Latest reply: Mar 28, 2012 10:44 AM by kgsmith5 RSS

    ODBC Connection

    kgsmith5

      I have a Qlikview application that uses and ODBC connection to get data from a database table. I am trying to set an alias for two fields, so that the fields will appear as lowercase values. This is not working for me and I am not sure how to force the alias for the field name to be loaded as lower case.

       

      SELECT


      N.ACCOUNT_ID,
      N.NAME_ID,
      AD.ZIP_CODE,
      Z.LATITUDE as latitude,
      Z.LONGITUDE as longitude,
      Z.DMA,
      Z.STATE,
      Z.STATION_SUPPORT

      FROM

      NAMES N,

      ADDRESSES AD,

      ZIP_CODE Z

       

      WHERE N.ACCOUNT_ID = AD.ACCOUNT_ID

      and N.PREFERRED_ADDRESS_ID = AD.ADDRESS_ID

      AND AD.ZIP_CODE = Z.ZIP_CODE

      When you go to the expression builder, the field names appear in all upper case, but I need them to be in lower case as the alias in the script.

      Can anyone help???