9 Replies Latest reply: May 13, 2013 2:55 AM by Qnica Krumova RSS

    TABLE NO FOUND, TABLA NO ENCONTRADA

      hI EVERYBODY, PLEASE HELP ME WITH THIS MISTAKE. MY SCRIP IS:

       

      TMP7:

      LOAD  Distinct "ref_num",

                "F_Apertura",

                "F_Resuelto",

                Grupo,

                Categoria_SLAIR,

                SLA_GRUPOS,

      Date,

      Start,

      End

       

       

      Resident SLA

      while daystart("F_Resuelto") >= daystart("F_Apertura")+iterno()-1;

       

       

      left join (SLA)

      LOAD

      Distinct "ref_num",

      fabs(interval(sum(End-Start))*24) as DurationScript2

      Resident TMP7  where WeekDay(Date)<5 and not match(Date,$(vHol));

      drop table TMP7;

       

       

      BUT WHEN I LOAD MY SCRIP, IT SHOWS ME A MESSAGE LIKE THIS:

       

      Tabla no encontrada

      left join (SLA)

      LOAD

      Distinct "ref_num",

      fabs(interval(sum(End-Start))*24) as DurationScript2

      Resident TMP7  where WeekDay(Date)<5 and not match(Date,41130,41140)

       

       

      PLEASE HELP ME.

       

      REGARDS

      DAPHNE.