Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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.
Try this syntax:
TableName:
Load *;
SQL SELECT *;
Store TableName into TableName.QVD;
Regards, Karl
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
//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);
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.