Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

while joining table is not found

hey everyone ,

i am getting the following error:

Table not found: LEFT JOIN(INV_SALES_TEMP) LOAD ACC_COSTFLAG AS INV_ACC_COSTFLAG, DATE((NUM(MAX(ACC_COSTDATE)))/60/24+32143,'DD/MM/YYYY') AS MAXACC_COSTDATE RESIDENT ACCDATES WHERE ACC_COSTDATE<>0 GROUP BY ACC_COSTFLAG

the thing is this that this table does exsist!

ACCDATES:

LOAD

CURDATE AS ACC_CURDATE,

COSTFLAG AS ACC_COSTFLAG,

COSTDATE AS ACC_COSTDATE

FROM [lib://Clinton key/Accdates.qvd]

(qvd);

i am adding a link to the real file:

clinton 21.12.2015.qvf - Google Drive

since it is a join i can't do a " No concatanate" action over here....

1 Solution

Accepted Solutions
Not applicable

Re: while joining table is not found

Hey for some reason the thing that made the error is this varailable :

IF(EnCurrency='NIS',Num(sum( {$< TRANS_TYPE = {N}>}  NIS_TRANS_TOTPRICE  )* -1,

IF(EnCurrency='$',Num(sum( {$< TRANS_TYPE = {N}>}  DOLLAR_TRANS_TOTPRICE )* -1,

IF(EnCurrency='EUR',Num(sum(  {$< TRANS_TYPE = {N}>}  CURRENCY_TRANS_TOTPRICE)* -1 ))))  ;

i guess it made concatanate ...

5 Replies
undergrinder
Valued Contributor II

Re: while joining table is not found

Hi Jhonatan,

I haven't enough time for dwelve into your qvf, but I have some tips for you:

  • Check, If INV_SALES_TEMP and ACCDATES tables are really exist

               Comment out your code until this block and check in data manager or in hub.

  • Check your code load order
  • Yeah, the No concatanate statement would be my 3rd advice ,  but not in join section,

          but at the loading the basic tables (INV_SALES_TEMP and ACCDATES). You'll see that after the first point.

          With column aliases you can prevent concatenate as well.


I hope, I was helpful


G.


nareshguntur
Valued Contributor

Re: while joining table is not found

Hi Jhonatan,

The file seems to be too big

My initial doubt is the table "ACCDATES" is not getting created whereas it is getting concatenated to another table during the script execution.

Please give a try.

Cheers,

Naresh

nareshguntur
Valued Contributor

Re: while joining table is not found

Just a thought.

I see a field ORD in the load statement of INV_SALES_TEMP which is getting highlighted. Its a Qlik function.

I hope this'll not be an issue but make sure that it is not the culprit.

Cheers,

Naresh

reddys310
Honored Contributor II

Re: while joining table is not found

Hi Jhonatan,

It could be the problem of auto-concatenation. Use a NoConcatenate before the load statement of INV_SALES_TEMP and it should work.

Not applicable

Re: while joining table is not found

Hey for some reason the thing that made the error is this varailable :

IF(EnCurrency='NIS',Num(sum( {$< TRANS_TYPE = {N}>}  NIS_TRANS_TOTPRICE  )* -1,

IF(EnCurrency='$',Num(sum( {$< TRANS_TYPE = {N}>}  DOLLAR_TRANS_TOTPRICE )* -1,

IF(EnCurrency='EUR',Num(sum(  {$< TRANS_TYPE = {N}>}  CURRENCY_TRANS_TOTPRICE)* -1 ))))  ;

i guess it made concatanate ...