i have a little problem with my master calendar. So i load only new record from database, then i get the date with a resident from that new record and i outer join that new date with date stored in qvd. After that i get duplicates. It looks like this:
V_ROUTEPOINT_NO_AGG:
LOAD
"TIME_KEY" as ROUTERPOINT_TIME_KEY,
(...)
SQL SELECT *
FROM (...)
WHERE TIME_KEY BETWEEN '$(vDayVariable)' AND '$(vDayNowVariable)'
LOAD
Timestamp(TimeStamp#(Left(ROUTERPOINT_TIME_KEY,12),'YYYYMMDDhhmm'),'YYYY-MM-DD hh:mm') as "GLOBAL_TIME_KEY",
Year(Timestamp(TimeStamp#(Left(ROUTERPOINT_TIME_KEY,12),'YYYYMMDDhhmm'),'YYYY-MM-DD hh:mm')) as GLOBAL_YEAR,
'Q' & ceil(Month(Timestamp(TimeStamp#(Left(ROUTERPOINT_TIME_KEY,12),'YYYYMMDDhhmm'),'YYYY-MM-DD hh:mm'))/3) as GLOBAL_QUARTER,
Month(Timestamp(TimeStamp#(Left(ROUTERPOINT_TIME_KEY,12),'YYYYMMDDhhmm'),'YYYY-MM-DD hh:mm')) as GLOBAL_MONTH,
(...)
Resident V_ROUTEPOINT_NO_AGG;
Outer Join(MasterCalendar)
LOAD * FROM (...);
Store MasterCalendar into (...);
Outer Join(V_ROUTEPOINT_NO_AGG)
LOAD * FROM (...);
Store V_ROUTEPOINT_NO_AGG into (...);
really i have no idea why Qlikview makes duplicates.
