How to create qvd file with alias columns names

[#1]

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

[its_anandrjs]

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

[its_anandrjs]

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

[#4]

Thanks Anand

[#5]

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

[its_anandrjs]

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

[#7]

How to get those 1000 column names ?

We need to type it manually or anyway to copy it.

Thanks,

Guru

[SunilChauhan]

use qulaify and unqualify

see the attached file

[its_anandrjs]

Hi,

You also give this names in load statement from there you just paste alias name there and give alias name there.

Regards,

Anand

[rwunderlich]

You can use RENAME statements as well to rename Fields.

-Rob