Hi,
I would like join ORDRE and a master calendar table called 'Master_Cal' on field 'OTSDTDEP' and I would to see these 2 tables separately. I need to see all the date values of the master calendar. So I did a right keep of ORDRE on Master_Cal like below but it doesn' work. It seems that only intersection has been taken.
Why ? Is there a solution for it ?
Right Keep(ORDRE)
Master_Cal:
LOAD
Floor(Date) as Opendate,
Date as OTSDTDEP,
Year(Date) as YearCal,
'S'& num(ceil(month(Date)/6)) as SemestreCal,
'T'& num(ceil(month(Date)/3)) as TrimestreCal,
MonthName(Date) as MoisCal,
year(Date) & '-' & Num(Month(Date),'00') as PERIODE_YM_Cal,
Day(Date) as DayCal//,
//Week(Date) as Week
Resident Calendar;
Best regards,
Michel
