Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all...
The below is the master cal Script:
QuartersMap:
MAPPING LOAD
rowno() as FYMonth,
'Q' & Ceil (rowno()/3) as Quarter
AUTOGENERATE (12);
Temp:
Load
date(yearstart(min(DateWID))) as minDate,
max(DateWID) as maxDate
Resident CombiKey;
Let vMin = Num(Peek('minDate', 0, 'Temp'));
Let vMax = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;
TempCal:
Load
Date(Date('$(vMin)')-1 + recno()) as Temp_Date
AUTOGENERATE (Date('$(vMax)')-Date('$(vMin)'))+1;
MasterCalendar:
LOAD Temp_Date as [DateWID],
Year(Temp_Date) as [Year],
day(Temp_Date)as day,
'Week' &week(Temp_Date) as Week,
MonthName(Temp_Date) as [Month Year],
ApplyMap('QuartersMap', Dual(Month( Date(Date#("Temp_Date",'MM/DD/YYYY'))),if(Month( Date(Date#("Temp_Date",'MM/DD/YYYY')))<4,Month( Date(Date#("Temp_Date",'MM/DD/YYYY')))+9,Month( Date(Date#("Temp_Date",'MM/DD/YYYY')))-3)), Null()) as Quarter,
Month(Temp_Date) as [Month],
Year(Temp_Date)&num(Month(Temp_Date),'00') as [MonthYear] ,
Year(YearStart( Date(Date#("Temp_Date",'MM/DD/YYYY')),0,4)) as FYYear,
YearName(Temp_Date,0,4) as [Fiscal Year],
Dual(Month( Date(Date#("Temp_Date",'MM/DD/YYYY'))),if(Month( Date(Date#("Temp_Date",'MM/DD/YYYY')))<4,Month( Date(Date#("Temp_Date",'MM/DD/YYYY')))+9,Month( Date(Date#("Temp_Date",'MM/DD/YYYY')))-3))
as FYMonth
Resident TempCal;
DROP Table TempCal;
Worked well until last week...now it is showing error as above.
Please help me find out the fixes.
HI
There is no values in the "Temp" folder.
i.e. CombiKey table doesn't have data. Check on this table and fix the issue.