Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Duplicated values in master calendar - outer join

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

0 Replies