topic Peculiar Table Not Found error in QlikView

Peculiar Table Not Found error

deekshith_juvva — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm kind of a beginner with QlikView. I'm trying to query a MySQL database to get around 50000 rows. I get the 'Table Not Found' error using the following code:

RawData:

SELECT *

FROM MyTable;

STORE RawData into ..\Data\RawData.qvd (qvd);

But not if I use the following code:

RawData:

SELECT *

FROM MyTable

LIMIT 10;

STORE RawData into ..\Data\RawData.qvd (qvd);

Any idea how to fix this?

Thanks,

Deekshith

Message was edited by: Deekshith Juvvadi

Re: Peculiar Table Not Found error

kaushiknsolanki — Tue, 13 Sep 2016 15:13:58 GMT

Hi,

Your script should be

RawData:

SELECT *

FROM MyTable;

STORE RawData into ..\Data\RawData.qvd (qvd);

But not if I use the following code:

RawData:

SELECT *

FROM MyTable

LIMIT 10;

STORE RawData into ..\Data\RawData.qvd (qvd);

Because Store will look for the Table Alice name which you have given, not the actual name of the table.

Regards,

Kaushik Solanki