topic Re: Error table not found, using STORE in QlikView

Error table not found, using STORE

danosoft — Thu, 26 Mar 2020 16:24:41 GMT

Hi, i have this error... when i do the STORE of my table in the script "table not found" where is the problem in my script?

CDG_Gas:
[...]

IF filetime('.\DataStores\V_FATTURATO_CDG_GAS_18.qvd') > 0 then
Concatenate:
CDG_Gas_18:
LOAD
*** from '.\DataStores\V_FATTURATO_CDG_GAS_18.qvd' (qvd);
ELSE
Concatenate:
CDG_Gas_18:
LOAD
***;
SQL SELECT *
FROM ***;
ENDIF
STORE CDG_Gas_18 INTO '.\DataStores\V_FATTURATO_CDG_GAS_18.qvd' (qvd);

Re: Error table not found, using STORE

m_woolf — Thu, 26 Mar 2020 17:11:11 GMT

It looks like your table name is CDG_Gas.

Put an exit script; before the Store line, reload and look at the table name to verify.

Re: Error table not found, using STORE

rubenmarin — Thu, 26 Mar 2020 18:13:56 GMT

Hi, CDG_Gas_18 has the same structure as CDG_Gas and is autoconcatenating, try with Nocontenate to avoid autoconcatenation:

CDG_Gas_18:
NoConcatenate LOAD

Re: Error table not found, using STORE

danosoft — Fri, 27 Mar 2020 07:49:09 GMT

Hi sorry but i want concatenate all two table.

And i want to store my table CDG_Gas_18 in the .qvd file, but when it execute the command STORE it do that error, why?

Re: Error table not found, using STORE

rubenmarin — Sun, 29 Mar 2020 19:25:17 GMT

Concatenate means that a table is added to another table, so table CDG_Gas_18 is not created and its values are added to CDG_Gas.

If you want to keeep them concatenated you need to use the first table: STORE CDG_Gas INTO '.\DataStores\V_FATTURATO_CDG_Gas.qvd' (qvd);

or: STORE CDG_Gas INTO '.\DataStores\V_FATTURATO_CDG_Gas_18.qvd' (qvd);

Re: Error table not found, using STORE

danosoft — Mon, 30 Mar 2020 13:29:26 GMT

ok understand, but i want have more .qvd one for every year (but the table are all concatenated)

for example

CDG_GAS

.....

STORE CDG_Gas INTO '.\DataStores\V_FATTURATO_CDG_Gas.qvd' (qvd);

CDG_GAS_18

.....

STORE CDG_Gas_18 INTO '.\DataStores\V_FATTURATO_CDG_Gas_18.qvd' (qvd);

CDG_GAS_19

.....

STORE CDG_Gas_19 INTO '.\DataStores\V_FATTURATO_CDG_Gas_19.qvd' (qvd);

but all those table need be concatenated becouse i need only a table in my dashboard

Re: Error table not found, using STORE

rubenmarin — Mon, 30 Mar 2020 14:08:38 GMT

You can change the order of script: first check the qvd that doesn't exists and create the qvds, after this load everything from qvds, like:

IF filetime('.\DataStores\V_FATTURATO_CDG_GAS_18.qvd') > 0 then // Nothing ELSE CDG_Gas_18: LOAD ***; SQL SELECT * FROM ***; // Store the table in qvd and delete the table STORE CDG_Gas_18 INTO '.\DataStores\V_FATTURATO_CDG_GAS_18.qvd' (qvd); DROP Table CDG_Gas_18; ENDIF

After all qvds are created load the data in a single table using qvds:

CDG_Gas: [...] Concatenate (CDG_Gas) LOAD *** from '.\DataStores\V_FATTURATO_CDG_GAS_18.qvd' (qvd); Concatenate (CDG_Gas) LOAD *** from '.\DataStores\V_FATTURATO_CDG_GAS_19.qvd' (qvd);

Or maybe just:

CDG_Gas: LOAD *** from '.\DataStores\V_FATTURATO_CDG_GAS*.qvd' (qvd);