Hi everyone!
im trying to run the script below but an error legend appear which saids
"Field not found - <AñoMes>
AsOf:
Load distinct AñoMes
Resident CALENDARIO_SUBSCRIPTIONS"
"Table not found
Left Join (AsOf)
Load AñoMes as AñoMesAsOf
Resident AsOf"
"Table not found
Inner Join (AsOf)
Load *
Resident AsOf
Where AñoMesAsOf >= AñoMes"
1) Script:
CALENDARIO_SUBSCRIPTIONS:
LOAD
Year(PeriodDate) & Num(Month(PeriodDate),'00') & Num(Day(PeriodDate),'00') as %Key_MODIFIED_SUBSCRIPTIONS,
Year(PeriodDate) as Año,
Month(PeriodDate) as Mes,
Day(PeriodDate) as Dia,
PeriodDate as Fecha,
DUAL(Month(PeriodDate) & '-' & Year(PeriodDate),
Year(PeriodDate) & Num(Month(PeriodDate),'00')) as AñoMes,
Week(PeriodDate) as Semana,
Ceil(Month(PeriodDate)/3) as Trimestre,
(Year(PeriodDate) * 12) + Num(Month(PeriodDate)) as LineaTemporal
RESIDENT TempCalendar;
AsOf:
Load distinct AñoMes
Resident CALENDARIO_SUBSCRIPTIONS;
Left Join (AsOf)
Load AñoMes as AñoMesAsOf
Resident AsOf;
Inner Join (AsOf)
Load *
Resident AsOf
Where AñoMesAsOf >= AñoMes;
thanks!
gerardo
