topic Re: Problem with right keep in App Development

Problem with right keep

olivier_vincon — Mon, 27 May 2019 16:33:52 GMT

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

Re: Problem with right keep

felipedl — Mon, 27 May 2019 18:40:48 GMT

Could you post the content of the ORDRE table?

Maybe its joining more than 1 field.

Re: Problem with right keep

olivier_vincon — Mon, 27 May 2019 20:07:05 GMT

No, I have seen the model, there is only the field 'OTSDTDEP' between these 2 tables.

But table ORDRE is linked to other tables.

Re: Problem with right keep

marcus_sommer — Tue, 28 May 2019 11:12:07 GMT

How did you check the data? I think they will be there - if you creates a tablebox and adds all fields from the Master_Cal you should see all records.

- Marcus