topic Re: Left outer join table in load statement in QlikView

Left outer join table in load statement

Anonymous — Mon, 23 Jul 2012 16:10:20 GMT

Hello,

What syntax I should use to get :

EmplHist table

Left outer join with this EESprvsr table.

After both both already load in qvw.

Tab: EEHIstory

//***********************
EmplHist:
LOAD EMPL_ID,
FULL_NAME,
Status,
HOME_ORG_ID,
TITLE_DESC,
GLC,
DATE(max([EMP_END_DATE])) as [END_DATE]

RESIDENT TempEmployeeHist
WHERE EXISTS (DirectOrg, HOME_ORG_ID) and EMP_END_DATE='12/31/2078'

GROUP BY EMPL_ID, FULL_NAME, Status, HOME_ORG_ID, TITLE_DESC, GLC;

DROP TABLE TempEmployeeHist;

Tab: Sprvsr

//******************

Sprvsr:
LOAD EMPL_GROUP_DESC as [SprvsrName],
EMPL_GROUP_CD as [SprvsrID];

SQL SELECT *
FROM [DELTEKTE].[TC_0012].[EMPL_GROUP]
WHERE LEFT([EMPL_GROUP_CD], 1) ='M'
;
LEFT JOIN (Sprvsr)
LOAD EMPL_ID as [TE_Employee_ID],
EMPL_GROUP_CD as [SprvsrID];

SQL SELECT *
FROM [DELTEKTE].[TC_0012].[EMPL_GROUP_EMPL]
;

Re: Left outer join table in load statement

jvitantonio — Tue, 24 Jul 2012 08:17:06 GMT

Do it like this

Table1:

Load Resident

EmplHist

;

Table2:

Left Join (Table1)

Load * resident EESprvsr ;

Re: Left outer join table in load statement

Sat, 24 Jan 2015 08:37:27 GMT

I think this answer is correct

Re: Left outer join table in load statement

maxgro — Sat, 24 Jan 2015 09:01:22 GMT

left join from a resident table, and rename the field te..emp..id to join

left join (EmplHist)

load

[SprvsrName],

[SprvsrID],

[TE_Employee_ID] as EMPL_ID

resident

Sprvsr;

then I think you have to drop Sprvsr

another way could be to change from

LOAD EMPL_ID as [TE_Employee_ID],

LOAD EMPL_ID as EMPL_ID,

and you shoul get 2 tables with an association by EMPL_ID

there is no need to add a left join in this way