topic Re: while joining table is not found in App Development

while joining table is not found

Mon, 21 Dec 2015 14:01:33 GMT

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....

Re: while joining table is not found

undergrinder — Mon, 21 Dec 2015 23:28:34 GMT

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

Re: while joining table is not found

NareshGuntur — Tue, 22 Dec 2015 05:15:51 GMT

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

Re: while joining table is not found

NareshGuntur — Tue, 22 Dec 2015 05:45:47 GMT

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

Re: while joining table is not found

reddy-s — Tue, 22 Dec 2015 12:17:37 GMT

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.

Re: while joining table is not found

Wed, 23 Dec 2015 12:13:18 GMT

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 ...