Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
PHONES:
Load PHONE as NEW_NAME;
SQL
SELECT
PHONE
FROM DIRECTORY
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.
Try like this
Department:
load
Code AS Dept_Code,
Name AS Dept_Name;
SELECT
Code ,
Name
FROM [NAV].[dbo].[$Dimension Value];
Hi all,
Thank you very much! It worked! Had no clue I had to do it before the SELECT.
Answered
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 .