RENAME FIELD ON SQL LOAD

[Anonymous]

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

[OmarBenSalem · Accepted solution]

Try:

PHONES:

Load PHONE as NEW_NAME;

SQL
SELECT

PHONE
FROM DIRECTORY

[ramasaisaksoft]

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]

Try like this

Department:

load

Code AS Dept_Code,

  Name AS Dept_Name;

SELECT

Code ,

Name

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

[Anonymous]

Hi all,

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

Answered

[oknotsen]

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 .