topic Re: table not found error on store as qvd. in QlikView

table not found error on store as qvd.

Wed, 17 Dec 2014 06:46:27 GMT

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?

Re: table not found error on store as qvd.

Wed, 17 Dec 2014 06:48:01 GMT

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

Re: table not found error on store as qvd.

anbu1984 — Wed, 17 Dec 2014 06:50:14 GMT

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

Re: table not found error on store as qvd.

saumyashah90 — Wed, 17 Dec 2014 06:55:25 GMT

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

Re: table not found error on store as qvd.

Wed, 17 Dec 2014 06:55:45 GMT

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)

Re: table not found error on store as qvd.

amit_saini — Wed, 17 Dec 2014 06:57:49 GMT

Sai,

It should be like below:

Table_Name:

SQL SELECT *

FROM CAQADMIN.STICHPROBE;

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

Thanks,

Re: table not found error on store as qvd.

saumyashah90 — Wed, 17 Dec 2014 06:58:51 GMT

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

Re: table not found error on store as qvd.

anbu1984 — Wed, 17 Dec 2014 07:00:19 GMT

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;

Re: table not found error on store as qvd.

Wed, 17 Dec 2014 07:02:14 GMT

Thanks Amit and others.

Re: table not found error on store as qvd.

amit_saini — Wed, 17 Dec 2014 07:04:19 GMT

Cheers!