qvd files

[#1]

hi

how to create qvd files for qlikview?

[CELAMBARASAN · Accepted solution]

Hi,

     Import table from database or other table files.

     Use store keyword.

     Example:

     Table1:

     Select * from Table1;

     STORE Table1 INTO FilePath\filename.qvd;

     or u can store selective fields

     STORE column1,column2 From Table1 INTO FilePath\filename.qvd;

Hope it helps

Celambarasan

[jagan]

Hi,

Use the below script to create qvd file.

TableName:

SQL Select * from Table; (For SQL database)

OR

TableName:

LOAD * from Datasource; ( For loading data from Excel, CSV, XMLetc.)

STORE TableName INTO QVDName.qvd;

Hope this helps you.

Regards,

Jagan.

[rwunderlich]

For more on creating QVDs, see http://robwunderlich.com/tutorials/.

-Rob