Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data source is from oracle,the table name is THISFUNDASSET.
L_DATE | L_ID | |
---|---|---|
2017-01-04 | 1 | |
| 2 | |
| 3 | |
| 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;
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,
AUTOGENERATE $(varMaxDate) - $(varMinDate) + 1;