topic Error: Table not found in QlikView

Error: Table not found

Wed, 28 Aug 2013 21:28:00 GMT

Hi everyone;

I have a query in distinc TAB the first tab is called Mexico and contains

CONNECT TO mgtmexbaan6 (XUserId is VaWfGcRNTLbIXcBK, XPassword is WBLbMZVMBDZWE);
companies:
SQL select
t_cwoc,
t_dsca,
t_comp
from ttcmcs065105 where t_typd = 2; //catalogo de purchase office
concatenate
SQL select
t_cwoc,
t_dsca,
t_comp
from ttcmcs065116 where t_typd = 2; //catalogo de purchase office
store companies into Dimensiones\companiestotal.qvd;

the other tab is called USA and contains

CONNECT TO WDM (XUserId is NSeUAcRNTTYeWTBM, XPassword is JTLCLZVMBDZIO);
companies400:
SQL select
t_cwoc,
t_dsca,
t_comp
from ttcmcs065400
where t_typd = 2; //catalogo de purchase office
store companies400 into Dimensiones\companiestotal400.qvd;
drop table companies400;

WHEN I run the .qvw appear the next error:

Table not Found

Can you help plis?

I attached FILE

Re: Error: Table not found

rlp — Wed, 28 Aug 2013 21:32:43 GMT

You should add :

NoConcatenate

between "companies400:" and "SQL SELECT"

Re: Error: Table not found

Wed, 28 Aug 2013 21:37:56 GMT

Hi Richard work it now but :

can you explain me please why this?

Regards!!

Re: Error: Table not found

fernando_tonial — Wed, 28 Aug 2013 21:41:42 GMT

QlikView automatically concatenate tables with the same number and field names.

Re: Error: Table not found

rlp — Wed, 28 Aug 2013 21:41:49 GMT

It's an odd feature of QV that i consider as a quasi-bug:

When two different tables have the same structure and even if you specify different names, QV put all in the first table, except if you specify NoConcatenate in the second LOAD so it's more simple to add it systematically.

Re: Error: Table not found

Wed, 28 Aug 2013 21:47:09 GMT

thanks for your help !!!!

Regards !!