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
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
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
Creator III
Creator III

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 ;