Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
;
Do it like this
Table1:
Load Resident
EmplHist
;
Table2:
Left Join (Table1)
Load * resident EESprvsr ;
I think this answer is correct
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],
to
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