topic Re: RENAME FIELD ON SQL LOAD in QlikView

RENAME FIELD ON SQL LOAD

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: RENAME FIELD ON SQL LOAD

OmarBenSalem — Thu, 23 Nov 2017 20:47:58 GMT

Try:

PHONES:

Load PHONE as NEW_NAME;

SQL
SELECT

PHONE
FROM DIRECTORY

Re: RENAME FIELD ON SQL LOAD

ramasaisaksoft — Fri, 24 Nov 2017 06:18:18 GMT

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.

Re: RENAME FIELD ON SQL LOAD

prma7799 — Fri, 24 Nov 2017 06:27:59 GMT

Try like this

Department:

load

Code AS Dept_Code,

Name AS Dept_Name;

SELECT

Code ,

Name

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

Re: RENAME FIELD ON SQL LOAD

Anonymous — Fri, 24 Nov 2017 08:18:46 GMT

Hi all,

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

Answered

Re: RENAME FIELD ON SQL LOAD

oknotsen — Fri, 24 Nov 2017 08:25:05 GMT

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 .