5 Replies Latest reply: Dec 23, 2015 7:13 AM by jhonatan ben ami RSS

    while joining  table is not found

    jhonatan ben ami

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