Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RobertPatrician
Contributor II
Contributor II

Resident Load doesn't recognize table name

LET vMinDate =Num('1/1/1970');
LET vMaxDate =Num('1/1/2050');

TempDates:
LOAD DATE($(vMinDate) + IterNo() - 1) AS TempDate
AutoGenerate (1)
WHILE $(vMinDate) + IterNo() - 1 <= $(vMaxDate);

-- Everything above this line works --

Dates:
NoConcatenate
Load
TempDate as Date,
Resident TempDates;
Drop table TempDates

 

By everything I can find online, this should produce one table of "Dates". Instead I get the below error message. If I comment out the Resident and drop table lines, I get only the "TempDates" table.

The following error occurred:
Unexpected token: 'TempDates', expected one of: ',', ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', ...
 
The error occurred here:
Dates:
NoConcatenate
Load
TempDate as Date,
Resident >>>>>>TempDates<<<<<<
 
Data has not been loaded. Please correct the error and try loading again.
 
My middle fingers are getting tired from angrily flipping off the computer monitor.
Labels (1)
1 Solution

Accepted Solutions
joseph_morales
Creator II
Creator II

Hi @RobertPatrician ,

The problem is the comma symbol (,) before resident and after the last Drop table function put a semicolon.

Dates:
NoConcatenate
Load
TempDate as Date
Resident TempDates;
Drop table TempDates;

Regards

 

 

Best Regards,
Joseph Morales

View solution in original post

2 Replies
joseph_morales
Creator II
Creator II

Hi @RobertPatrician ,

The problem is the comma symbol (,) before resident and after the last Drop table function put a semicolon.

Dates:
NoConcatenate
Load
TempDate as Date
Resident TempDates;
Drop table TempDates;

Regards

 

 

Best Regards,
Joseph Morales

View solution in original post

NitinK7
Specialist
Specialist

Hi

remove comma (,) after the tempDate as date

 and put semicolon after drop table statement

Dates:
NoConcatenate
Load
TempDate as Date,
Resident TempDates;
Drop table TempDates ;