krish2459
Creator
2022-10-30
01:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oracle query Join into Qlik data model
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...
378 Views
1 Reply
rubenmarin
MVP
2022-10-30
07:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
343 Views