Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to create qvd file with alias columns names

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

9 Replies

How to create qvd file with alias columns names

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

How to create qvd file with alias columns names

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

Not applicable

How to create qvd file with alias columns names

Thanks Anand

Not applicable

How to create qvd file with alias columns names

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

How to create qvd file with alias columns names

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

Not applicable

How to create qvd file with alias columns names

How to get those 1000 column names ?

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

Thanks,

Guru

chauhans85
Esteemed Contributor

Re: How to create qvd file with alias columns names

use qulaify and unqualify

see the attached file

How to create qvd file with alias columns names

Hi,

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

Regards,

Anand

How to create qvd file with alias columns names

You can use RENAME statements as well to rename Fields.

-Rob

Community Browser