Table not found Error

[#1]

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

[sunny_talwar]

Do you have a table named Avi which appears before this script for master calendar?

[maxgro]

TempCalender  vs TempCalendar

TempCalender:

LOAD

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

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

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

[sunny_talwar]

Very sharp

[Anonymous]

Indeed, using Drop Table TempCalender; instead of Drop Table TempCalendar; should resolve the issue.

[#6]

It worked for me. Thanks for highlighting the error.