QVD Files

[#1]

Hi Guys

I am trying to create a qvd file .. i am new to this... after writting the store statement I dont see the qvd file where i stored it

Store PhoneReportData into C:\QlikviewReports\WorkingDocuments\QVD\Phones.qvd;

Any explenation?!

Thanks!

[#2]

All what i want is to create the QVD files and then i'll go from there

[#3]

You're aliasing your tables during your load by using labels in you script

TableSALESMAN:

Load

*

From NEPTUNE.SDDTA.SALESMAN;

The table name as far as QlikView is concerned is TableSALESMAN, not NEPTUNE.SDDTA.SALESMAN.

In your example  your code should look like this:

TableCUSORD:

Load

*

From NEPTUNE.SDDTA.CUSORD;

Store TableCUSORD into CUSORD.qvd;

TableSALESMAN:

Load

*

From NEPTUNE.SDDTA.SALESMAN;

Store TableSALESMAN into SALESMAN.qvd;

Drop tables TableCUSORD, TableSALESMAN;

Load

*

From  CUSORD.qvd;

Load

*

From SALESMAN.qvd;

[its_anandrjs]

Hi,

Sorry for response late for your code you have to write

TableCUSORD:

Load

*

From NEPTUNE.SDDTA.CUSORD;

Store TableCUSORD into TableCUSORD.qvd;

TableSALESMAN:

Load

*

From NEPTUNE.SDDTA.SALESMAN;

Store TableSALESMAN into TableSALESMAN.qvd;

Drop tables TableCUSORD, TableSALESMAN;

//Loading from QVD

Load

*

From  TableCUSORD.qvd;

Load

*

From TableSALESMAN.qvd;

From any location or alias you can load the tables but when you give name to table in Qlikview it recognize with that name in this case there is two tables TableCUSORD, TableSALESMAN so load data like this

Rgds

Anand