Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

table not found error on store as qvd.

Hi All,

I get an error table not found when I try to load table from the database and save as qvd format with store command. The table exists in the db though . This is the first time I am trying to store in qvd format . I just followed the same steps as in the help section. Can anyone help me?

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Sai,

It should be like below:

Table_Name:

SQL SELECT *

FROM CAQADMIN.STICHPROBE;

store Table_name into D:\Asaini\Test\Table_Name.qvd;

Thanks,

AS

View solution in original post

9 Replies
Highlighted
Not applicable

the same loads when I do it with the select command though.

Highlighted
Master III
Master III

Can you post the script?

Did you define table name as below before you store into QVD?

TableNm:

Sql Select * from table;

Store TableNm into Qvd(qvd);

Highlighted
Specialist
Specialist

if loading from flat files:

Table1:

Load * from XYZ(Path/table);

Store Table1 into Path/Table1.qvd(QVD);

And similarly if you are loading from database

Table2:

Sql Select * from Table;

Store Table2 into Path/Table2.qvd(QVD);

//Path= path of the file where you want to store or load it from

Highlighted
Not applicable

STORE tetower into ttower.qvd;

(this is the store command I used to store the table in qvd format)

//SQL SELECT *

//FROM "TEF_UAT_NEW".dbo.tetower

(the same table that loads without store command)

Highlighted
Master III
Master III

Sai,

It should be like below:

Table_Name:

SQL SELECT *

FROM CAQADMIN.STICHPROBE;

store Table_name into D:\Asaini\Test\Table_Name.qvd;

Thanks,

AS

View solution in original post

Highlighted
Specialist
Specialist

Whenever you load put a Name of the table.

i.e

Table1:

SQL SELECT *

FROM "TEF_UAT_NEW".dbo.tetower ;

//Store Command

Store Table1 into Table1.qvd(QVD);

Highlighted
Master III
Master III

You cannot use sql table name directly in store statement. Table name has to be mentioned before your Select like below and use the same in Store statement

tetower:

SQL SELECT *

FROM "TEF_UAT_NEW".dbo.tetower;

STORE tetower into ttower.qvd;

Highlighted
Not applicable

Thanks Amit and others.

Highlighted
Master III
Master III

Cheers!