Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error: Table not found

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

1 Solution

Accepted Solutions
rlp
Creator
Creator

You should add :

NoConcatenate

between "companies400:" and "SQL SELECT"

View solution in original post

5 Replies
rlp
Creator
Creator

You should add :

NoConcatenate

between "companies400:" and "SQL SELECT"

Not applicable
Author

Hi Richard work it now but :

can you explain me please why this?

Regards!! 

fernando_tonial
Partner
Partner

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

rlp
Creator
Creator

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.

Not applicable
Author

thanks for your help !!!!

Regards !!