Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
richard_pressan
Contributor

Re: Error: Table not found

You should add :

NoConcatenate

between "companies400:" and "SQL SELECT"

5 Replies
richard_pressan
Contributor

Re: Error: Table not found

You should add :

NoConcatenate

between "companies400:" and "SQL SELECT"

Not applicable

Re: Error: Table not found

Hi Richard work it now but :

can you explain me please why this?

Regards!! 

fernando_tonial
Valued Contributor

Re: Error: Table not found

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

richard_pressan
Contributor

Re: Error: Table not found

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

Re: Error: Table not found

thanks for your help !!!!

Regards !!