while joining table is not found

[#1]

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

[undergrinder]

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]

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]

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

[reddy-s]

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.

[#6 · Accepted solution]

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