Oracle query Join into Qlik data model

[krish2459]

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...

[rubenmarin1]

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