Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm beginner to qlikview.
I'm having qvd files for tables with more than 1000 columns.
I want to create alias names for few columns in that qvd file while loading into developer.
Can anyone assist me in this ??
Thanks and Regards,
Guru
Hi.
You want to create a QVD file so for that you need to put a code.
TableName:
Load
Column1,
.....
From FileName;
Store into TableName TableName.qvd;
With this suntax you are create a QVD.
Reagrds,
Anand
Hi,
When ever you create a QVD it store that column names which are available in the table from which you create a QVD file, if you want to add alias names so in this case change it in the table then create a table or load from resident table.
Regards,
Anand
Thanks Anand
Hi Anand,
For viceversa, i.e. while loading from qvd file to developer, if we want to create alias names for columns(nearly 1000) in that qvd file, how to make it ??
Regards,
Guru
Hi,
When you load from the QVD on load script you need to put as Column Alias Name.
Load
ColumnName as Alias Name
...
...
...
From QVD Load
Reagrds,
Anand
How to get those 1000 column names ?
We need to type it manually or anyway to copy it.
Thanks,
Guru
use qulaify and unqualify
see the attached file
Hi,
You also give this names in load statement from there you just paste alias name there and give alias name there.
Regards,
Anand
You can use RENAME statements as well to rename Fields.
-Rob