3 Replies Latest reply: Feb 2, 2014 10:35 AM by Sevda Yaman RSS

    WHERE.... garbage after statement ERROR


      HI ALL,

       

      This produces the dreaded "Garbage after statement...." ....Am not I concatenating the new data with qvd.

       

      LOAD date(gun) as gun,
      sayı
      FROM
      a.xlsx
      (
      ooxml, embedded labels, table is Sayfa1);
      store data into data.qvd;
      data:
      LOAD gun,
          
      sayı
      FROM
      data.qvd
      (
      qvd);
      max_gun:
      load date(max(gun)) as max
      Resident data;
      let vmax=Peek('max',0,'max_gun');
      drop table data;
      NoConcatenate
      Incremental:
      LOAD gun,
          
      sayı
      From
      a.xlsx
      (
      ooxml, embedded labels, table is Sayfa2)
      where gun>= $(vmax);
      Concatenate
      LOAD date(gun) as gun,
          
      sayı
      FROM
      data.qvd
      (
      qvd)
      where not Exists(sayı);
      store Incremental into data.qvd(qvd);
      drop Table Incremental;

       

       

       

      Any ideas? PLEASE HELP!!!