topic Error While creating the QVD table in QlikView

Error While creating the QVD table

Sat, 10 Jul 2010 14:01:51 GMT

Hi,

I am new to QlikView.

I am trying to create the QVD table explicity using the Store statement from the File-Edit script section. I am getting the Error as Table not found. If i am trying with Buffer it is working fine.

Please find the scripts i tried to create the QVD table

CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=XXXX;Data Source=XXXX;Extended Properties=""] (XPassword is XXXXX);

STORE

* FROM XXXX WHERE Status<4 into test.qvd;

Also i tried to create by the below way as well

CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=XXXX;Data Source=XXXX;Extended Properties=""] (XPassword is XXXXX);

STORE

* FROM XXXXX WHERE Status<4 into {C:\Documents and Settings\All Users\Application Data\QlikTech\QlikView\test.qvd];

Please help me on this issues. Is it like i need to create the table and then use the table in the Store statement. If so please let me

know the step by step .

Error While creating the QVD table

pover — Sat, 10 Jul 2010 20:42:50 GMT

Try this syntax:

TableName:
Load *;
SQL SELECT *;

Store TableName into TableName.QVD;

Regards, Karl

Error While creating the QVD table

Sun, 11 Jul 2010 11:19:50 GMT

Hi Karl,

In your response i can see that in the Store command you have removed the * and asked me try the same and added the Load statement. I tried the same but still same response. Table not found. Please find the code i have used

Load *;

SELECT * FROM tablename WHERE XXXX<4;

STORE tablename INTO

Also tried without giving the location.

Load *;

SELECT * FROM tablename WHERE XXXX<4;

STORE tablename INTO

Even i have created the test.qvd in the mentioned loaction. But in vein i am not able to Store in to the Qvd file.Actual Requirement is i need to load the incremental data for a specific Requirement. But i am not able to create the normal Qvd file. Please help to solve this

Error While creating the QVD table

Sun, 11 Jul 2010 12:35:16 GMT

//connection string to database

CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=XXXX;Data Source=XXXX;Extended Properties=""] (XPassword is XXXXX);

//load data from database to Qlikview Table in memory

Test:
SQL SELECT * FROM XXXXX WHERE Status<4;

//store Qlikview Table from memory to disk

store Test into C:\Documents and Settings\All Users\Application Data\QlikTech\QlikView\test.qvd (qvd);

Error While creating the QVD table

Sun, 11 Jul 2010 13:26:06 GMT

Thanks karoldorniak. Its working now. I didnt mention the file name in the previous Scripts.Hence i was getting the Error. Now i am trying to update the QVD file in the incremental option to find the trending on each day.