3 Replies Latest reply: Aug 5, 2015 10:08 AM by Mark Graham RSS

    Script execution error

    Mark Graham

      Hi all,

       

      Can someone help me in identify the reason for script failure.

      My script is as follows:

       

      Temp:

      Load

      min([Ship Date]) as minDate,

      max([Ship Date])+1 as maxDate

      Resident Temp;

       

      Let varMinDate = Num(Peek('minDate', 0, 'Temp'));

      Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

      Let varCurrentYear = year(Peek('maxDate'));

      Let varCurrentMonth = MonthName(Peek('maxDate'));

      Let varCurrentQuarter = QuarterName(Peek('maxDate'));

      DROP Table Temp;

       

      TempCalendar:

      LOAD

      $(varMinDate) + Iterno()-1 As Num,

      Date($(varMinDate) + IterNo() - 1) as TempDate

      AutoGenerate 1 While $(varMinDate) + IterNo()-1 <= $(varMaxDate);

       

      Error:

      TempCalendar:

      LOAD

        + Iterno()-1 As Num,

        Date( + IterNo() - 1) as TempDate

      AutoGenerate 1 While  + IterNo()-1 <=

         Error: Field not found - <<=>

        General Script Error

      Execution Failed

      Execution finished.