Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Mark,
Your variables varMinDate and varMaxDate are Null because You have
Temp:
Load
min([Ship Date]) as minDate,
max([Ship Date])+1 as maxDate
Resident Temp;
Hi Mark,
quite simple, you're missing an item following this mathematical operator.
HTH
Hi Mark,
Your variables varMinDate and varMaxDate are Null because You have
Temp:
Load
min([Ship Date]) as minDate,
max([Ship Date])+1 as maxDate
Resident Temp;
Hi Antonio,
Thanq verymuch.
Didn't notice that. It was Temp2 which is being loaded in the previous tab.
Thanq