Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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?

Tags (1)
1 Solution

Accepted Solutions
amit_saini
Honored Contributor III

Re: table not found error on store as qvd.

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

9 Replies
Not applicable

Re: table not found error on store as qvd.

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

anbu1984
Honored Contributor III

Re: table not found error on store as qvd.

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);

saumyashah90
Valued Contributor

Re: table not found error on store as qvd.

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

Not applicable

Re: table not found error on store as qvd.

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)

amit_saini
Honored Contributor III

Re: table not found error on store as qvd.

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

saumyashah90
Valued Contributor

Re: table not found error on store as qvd.

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);

anbu1984
Honored Contributor III

Re: table not found error on store as qvd.

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;

Not applicable

Re: table not found error on store as qvd.

Thanks Amit and others.

amit_saini
Honored Contributor III

Re: table not found error on store as qvd.

Cheers!