Duplicated values in master calendar - outer join

Tue, 30 Sep 2014 11:06:29 GMT

Hello,

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.

Thanks in advance,

Jacek

topic Duplicated values in master calendar - outer join in QlikView

Duplicated values in master calendar - outer join