topic Re: Table not found error while reloading the data from the script from Oracle database in QlikView

Table not found error while reloading the data from the script from Oracle database

Fri, 26 Oct 2012 11:23:22 GMT

Hi,

As i want to store the data in the form of qvd and i have mentioned in the script as

script: sql query followed by the below statement

store tablename into tablename.qvd(qvd);

but the data is not storing inthe form of qvd in the mentioned path throwing the error message as table not found ,please help me out how i ca resolve this as i am new to this still learning .

Regards,

Smita

Re: Table not found error while reloading the data from the script from Oracle database

Gysbert_Wassenaar — Fri, 26 Oct 2012 11:29:00 GMT

Did you specify a name for the table into which to load the result from your sql statement?

mytablename:

select .... etc;

store mytablename into tablename.qvd (qvd);

Re: Table not found error while reloading the data from the script from Oracle database

Fri, 26 Oct 2012 11:39:29 GMT

Plese See The Attachment

I hope it works fine

08015258712

Re: Table not found error while reloading the data from the script from Oracle database

Sat, 27 Oct 2012 11:01:37 GMT

oh yes i have not mentioned the table name in the begining of the sql query that 's why it's throwing the error now i resolved this . thanks for the help.

Regards,

Smita

Re: Table not found error while reloading the data from the script from Oracle database

Wed, 31 Oct 2012 17:45:19 GMT

Hello Waseenar ,

Eventhough I gave the table name while converting into qvd using store,I am getting the same error can you please tell me what is the problem