topic Re: Rename field on a SQL LOAD in QlikView

Rename field on a SQL LOAD

Anonymous — Wed, 22 Nov 2017 16:38:30 GMT

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!

surendraj — Mon, 27 Nov 2017 13:21:10 GMT

load PHONE as client phone

SQL
SELECT
PHONE

FROM PHONES

surendraj — Mon, 27 Nov 2017 13:23:04 GMT

load PHONE as "client phone";

SQL
SELECT
PHONE

FROM PHONES

stabben23 — Mon, 27 Nov 2017 13:23:04 GMT

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

Anonymous — Mon, 27 Nov 2017 13:23:50 GMT

You use as in a preceding load.

LOAD

PHONE as [CLIENT PHONE]

SQL

SELECT

PHONE

FROM PHONES;