Resident Load doesn't recognize table name

[RobertPatrician]

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.

[joseph_morales · Accepted solution]

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

[NitinK7]

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 ;