Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please help to convert the below oracle query join condition in qlik data model join condition.
where
( XXDC_REGISTRATION.REGISTRATION_ID = XXDC_REGISTRATION_HISTORY.REGISTRATION_ID (+)
AND XXDC_REGISTRATION.DOC_OK = XXDC_REGISTRATION_HISTORY.DOC_OK (+) )
AND (XXDC_COMM_SE.EMPLOYEE_ID = XXDC_OBI_EMP_HIER_SV.EMPLOYEE_ID (+)
Thanks...
Hi, Qlik does the joins base on fields with the same name, so just use "inner join" on the tables where only those fields has the same name in both tables.
LOAD
REGISTRATION_ID,
DOC_OK,
EMPLOYEE_ID,
OTHER_FIELD_WHIT_SAME_NAME
From... table1
Inner Join
LOAD
REGISTRATION_ID,
DOC_OK,
EMPLOYEE_ID,
OTHER_FIELD_WHIT_SAME_NAME as CHANGED_NAME
From... table2