Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table not found Error

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

5 Replies
sunny_talwar

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

maxgro
MVP
MVP

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
Not applicable
Author

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

Not applicable
Author

It worked for me. Thanks for highlighting the error.