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;
