Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

davidgutierrezv
New Contributor

RENAME FIELD ON SQL LOAD

Hi all,

Im trying to rename a field at the time Im doing the LOAD from a Teradata server, but I cant seem to figure out how to do it. Please help me!

PHONES:
SQL
SELECT

PHONE

FROM DIRECTORY

I just want something like this

PHONES:
SQL
SELECT

PHONE as NEW_NAME

FROM DIRECTORY

THANK YOU VERY MUCH

1 Solution

Accepted Solutions
Partner
Partner

Re: RENAME FIELD ON SQL LOAD

Try:

PHONES:


Load PHONE as NEW_NAME;

SQL
SELECT

PHONE
FROM DIRECTORY

5 Replies
Partner
Partner

Re: RENAME FIELD ON SQL LOAD

Try:

PHONES:


Load PHONE as NEW_NAME;

SQL
SELECT

PHONE
FROM DIRECTORY

ramasaisaksoft
Valued Contributor III

Re: RENAME FIELD ON SQL LOAD

Hi David,

always Alias name we need to do in Load statement only.

otherwise we need to do in database itself and create a new field like that in Data base table itself .

then we will fetch as new column into QlikView.

prma7799
Honored Contributor III

Re: RENAME FIELD ON SQL LOAD

Try like this

Department:

load

Code AS Dept_Code,

  Name AS Dept_Name;

SELECT

Code ,

Name

FROM  [NAV].[dbo].[$Dimension Value];

davidgutierrezv
New Contributor

Re: RENAME FIELD ON SQL LOAD

Hi all,

Thank you very much! It worked! Had no clue I had to do it before the SELECT.

Answered

oknotsen
Honored Contributor III

Re: RENAME FIELD ON SQL LOAD

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!