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,
You want to create a QVD file so for that you need to put a code.
Store into TableName TableName.qvd;
With this suntax you are create a QVD.
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.
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 ??
When you load from the QVD on load script you need to put as Column Alias Name.
ColumnName as Alias Name
From QVD Load
How to get those 1000 column names ?
We need to type it manually or anyway to copy it.
use qulaify and unqualify
see the attached file
You also give this names in load statement from there you just paste alias name there and give alias name there.
You can use RENAME statements as well to rename Fields.
Retrieving data ...