Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aghabdurauf
Contributor III
Contributor III

Qlik & SAP S/4 HANA an d Oracle DB

Hi,

I have data in SAP S/4 HANA and other data in Oracle DB, I want to fetch data from both DB's and import to Qlik Sense, but the problem is that the data in both DBs are same and containing same keys and want to fetch data from both DBs.

Regards

Abdul  Rauf

 
Labels (4)
1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi,

Do the following:

  1. Determine which database is leading
  2. Then load the data from the other database and do a 'Where exists' on the key field

Now you always will have all the data and no doubles.

Jordy
Climber

Work smarter, not harder