Invalid Autogenerage count:-1

[#1]

My data source is from oracle,the table name is THISFUNDASSET.

L_DATE	L_ID
2017-01-04	1
2017-01-04	2
2017-01-04	3
2017-01-04	4
2016-08-05	5
2018-08-05	6

my script is:

LET varMinDate = NUM(PEEK('L_DATE',0,'THISFUNDASSET'));

LET varMaxDate = NUM(PEEK('L_DATE',-1,'THISFUNDASSET'));

TempCalendar:

Load

DATE($(varMinDate ) + ROWNO() -1) AS TempDate

AUTOGENERATE$(varMaxDate ) - $(varMinDate ) + 1;

MasterCalendar:

Load

DATE(TempDate) as Date,

WEEK(TempDate) as Week,

..........................

my problem is :

Invalid Autogenerate count:-1:TempCalendar:Load DATE($(varMinDate ) + ROWNO() -1) AS TempDate AUTOGENERATE -+1;

[sunny_talwar]

May be try like this

MinMax:

LOAD Min(L_DATE) as MinDate

          Max(L_DATE) as MaxDate

Resident THISFUNDASSET;

LET varMinDate = Peek('MinDate');

LET varMaxDate = Peek('MaxDate');

TempCalendar:

Load

DATE($(varMinDate ) + ROWNO() -1) AS TempDate

AUTOGENERATE$(varMaxDate ) - $(varMinDate ) + 1;

MasterCalendar:

Load

DATE(TempDate) as Date,

WEEK(TempDate) as Week,

[maxgro]

AUTOGENERATE $(varMaxDate) - $(varMinDate) + 1;