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.
N.ACCOUNT_ID, N.NAME_ID, AD.ZIP_CODE, Z.LATITUDE as latitude, Z.LONGITUDE as longitude, Z.DMA, Z.STATE, Z.STATION_SUPPORT
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.
I believe it would look something like this for you. you just do all the name changing and any other changes here.
N.ACCOUNT_ID as 'Account ID', N.NAME_ID as 'Name ID', AD.ZIP_CODE as 'Zip Code', Z.LATITUDE as Latitude, Z.LONGITUDE as Longitude, Z.DMA as DMA, Z.STATE as State, Z.STATION_SUPPORT as 'Station Support';