1 Reply Latest reply: Nov 6, 2012 9:40 AM by Erich Shiino RSS

    BUFFER LOAD - right parenthesis is missing

    Helen Pippard

      Hello,

       

      Could someone kindly help me with why my LOAD is not working correctly

       

      I get an error message of:  right parenthesis is missing

       

       

      current_breeches:

      BUFFER(Stale after 1 hour) LOAD

       

      attendance_id

      ,
      attendance_arrivaldate,
      Breach_Location,
      cat_currentlocid,
      end_date,
      waiting_time,
      Breaches;
      SELECT * FROM C:\QLIKVIEW\DEVELOPMENT\HP\QVD\CURRENT_BREACHES.qvd
      (qvd);

       

      Also if I take the buffer load statement out my QVD brings through old data and does not refresh itself

       

      Any ideas?

       

      Kind Regards

      Helen

        • Re: BUFFER LOAD - right parenthesis is missing
          Erich Shiino

          Hi, Helen

          I did the following script ( which is similar and it worked)

           

          buffer (stale after 7 days)

          Test:

          LOAD *

          FROM

          Template.xlsx

          (ooxml, embedded labels, table is X);

           

          Maybe it will work if you simplify the code like this:

           

          current_breeches:

           

          BUFFER(Stale after 1 hour) LOAD

           

           

          attendance_id

          ,
          attendance_arrivaldate,
          Breach_Location,
          cat_currentlocid,
          end_date,
          waiting_time,
          Breaches
          FROM C:\QLIKVIEW\DEVELOPMENT\HP\QVD\CURRENT_BREACHES.qvd
          (qvd);

           

          Hope it helps,

           

          Erich