topic Re: Getting Error Table not found in App Development

Getting Error Table not found

akar_0308 — Tue, 13 Apr 2021 15:25:44 GMT

Hello, I have an error in the script 'table not found'

FOR(J=with some condition)

TAB1:

LOAD

A,B,C,D,E

SQL

SELECT A,B,C, D,SUM(X) as E from v_DB.DB_TAB1 Group by A,B,C,D;

TAB2:

LOAD

A,B,C,D,X,Y,Z

SELECT * from v_DB.DB_TAB2;

LEFT JOIN(TAB1)

LOAD

A,B,C,D,

Sum(X),

SUM(if(Y=1,X,0)) as SUM_TYPE1,

SUM((if(Y=2,X,0)) as SUM_TYPE2,

RESIDENT TAB2;

Group by A, B,C,D

Next J;

DROP table TAB2;

Re: Getting Error Table not found

GaryGiles — Tue, 13 Apr 2021 21:46:16 GMT

Is there any chance that you are loading a table in your load script with the fields A,B,C,D,X,Y,Z prior to this section of code running? If Qlik encounters a load for a table with the same columns as a previously loaded table, it will concatenate the subsequent table to the first table. You can prevent this with a Noconcatenate statement before loading TAB2.

Try this:

Noconcatenate

TAB2:

LOAD

A,B,C,D,X,Y,Z

SELECT * from v_DB.DB_TAB2;

Re: Getting Error Table not found

marcus_sommer — Wed, 14 Apr 2021 09:43:39 GMT

Joins within a loop are very problematic and will mostly don't work - because already in the second iteration the join will be applied on the extra added fields from the first iteration. Further the new added fields change the table-structure and therefore the second iteration won't load the data within the origin defined table else Qlik creates a new one by appending a continuous number to the table-name.

I don't want to say that's impossible to use such an approach - you may apply a forced concatenation and/or renaming fields and tables for and back and/or using some intermediated steps with extra stored/loaded tables and similar measures but I wouldn't recommend this direction because nearly always are better and easier approaches possible - especially from a performance point of view are such outside-loops very slow if it comes to many iterations.

- Marcus

Re: Getting Error Table not found

akar_0308 — Thu, 15 Apr 2021 21:32:14 GMT

Hello ,

it works when i have put the left join jus after the loop ,

LEFT JOIN(TAB1)

LOAD

A,B,C,D,

Sum(X),

SUM(if(Y=1,X,0)) as SUM_TYPE1,

SUM((if(Y=2,X,0)) as SUM_TYPE2,

RESIDENT TAB2;

Group by A, B,C,D