Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akar_0308
Contributor II
Contributor II

Getting Error Table not found

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;

 

 

 

1 Solution

Accepted Solutions
akar_0308
Contributor II
Contributor II
Author

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

View solution in original post

3 Replies
GaryGiles
Specialist
Specialist

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;

marcus_sommer

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

akar_0308
Contributor II
Contributor II
Author

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