topic Re: Table not found Error in QlikView

Table not found Error

Thu, 11 Aug 2016 12:44:29 GMT

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

Re: Table not found Error

sunny_talwar — Thu, 11 Aug 2016 14:45:20 GMT

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

Re: Table not found Error

maxgro — Thu, 11 Aug 2016 14:51:26 GMT

TempCalender vs TempCalendar

TempCalender:

LOAD

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

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

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

Re: Table not found Error

sunny_talwar — Thu, 11 Aug 2016 14:53:07 GMT

Very sharp

Re: Table not found Error

Anonymous — Thu, 11 Aug 2016 15:06:56 GMT

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

Re: Table not found Error

Thu, 11 Aug 2016 17:03:16 GMT

It worked for me. Thanks for highlighting the error.