Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I was trying to exceute the below script but i am getting an error as "TABLE NOT FOUND"
The Script is as below
QuartersMap:
MAPPING LOAD
rowno() as Month,
'Q' & Ceil (rowno()/3) as Quarter
AUTOGENERATE (12);
Temp:
load
min([Start Date]) as mindate,
max([Start Date]) as maxdate
Resident Avi;
let varMinDate=Num(Peek('mindate',0,'Temp'));
let varMaxDate=Num(Peek('maxdate',0,'Temp'));
DROP Table Temp;
TempCalender:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
NewCalender:
Load
TempDate as [Start Date],
week(TempDate) as Week_Number,
Year(TempDate) as Year,
Month(TempDate) as Month,
Day(TempDate) as Day,
WeekDay(TempDate) as WeekDay
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
Can someone help me out to resolve this
Do you have a table named Avi which appears before this script for master calendar?
TempCalender vs TempCalendar
TempCalender:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
Very sharp
Indeed, using Drop Table TempCalender; instead of Drop Table TempCalendar; should resolve the issue.
It worked for me. Thanks for highlighting the error.