Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
davidgutierrezv
New Contributor

Rename field on a SQL LOAD

Hi all,

Please help me with this simple question     

Im trying to LOAD some data from a server hosted on TERADATA, and i would like to rename the "phone" field as "client phone" on the load.

any suggestions???

EXAMPLE:
SQL
SELECT
       PHONE

FROM PHONES

thank u very much!

1 Solution

Accepted Solutions
Highlighted
stabben23
Honored Contributor

Re: Rename field on a SQL LOAD

I'll think you have answer Your own question. it simply this

SQL
SELECT
       PHONE as "Client Phone"

FROM PHONES

or if you use preceding LOAD instead

LOAD

PHONE as "Client Phone"

;

SQL
SELECT
       PHONE

FROM PHONES

View solution in original post

4 Replies
Highlighted
surendraj
Valued Contributor

Re: Rename field on a SQL LOAD

load PHONE as client phone

SQL
SELECT
       PHONE

FROM PHONES

Highlighted
surendraj
Valued Contributor

Re: Rename field on a SQL LOAD

load PHONE as "client phone";

SQL
SELECT
       PHONE

FROM PHONES

Highlighted
stabben23
Honored Contributor

Re: Rename field on a SQL LOAD

I'll think you have answer Your own question. it simply this

SQL
SELECT
       PHONE as "Client Phone"

FROM PHONES

or if you use preceding LOAD instead

LOAD

PHONE as "Client Phone"

;

SQL
SELECT
       PHONE

FROM PHONES

View solution in original post

Highlighted
bvk
Contributor II

Re: Rename field on a SQL LOAD

You use as in a preceding load.

LOAD

     PHONE as [CLIENT PHONE]

SQL

SELECT

     PHONE

FROM PHONES;