Error: Table not found

[#1]

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

[rlp · Accepted solution]

You should add :

NoConcatenate

between "companies400:" and "SQL SELECT"

[#3]

Hi Richard work it now but :

can you explain me please why this?

Regards!! 

[fernando_tonial]

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

[rlp]

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.

[#6]

thanks for your help !!!!

Regards !!