Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

How do we join two different SQL Queries from different provider

I have two different queries.

One query (query1), i am using SQL server data. using LOAD Queries.

other query (query2), i am using Oracle data using SELECT Statement. (Oracle query is heavy and i am using select statement.

how do we join both LOAD and SELECT (SQL SERVER and ORACLE) and finally get one single query..?

Example : 

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist............

SQLTABLE1:

LOAD EmpNo.Name,Section;

SQL SELECT * from "EmpTable1";

ORACLETABLE2:

SELECT EmpNo.Name,Section where EmpNo in ('EMP101','EMP102');

How to join the above

Labels (1)
1 Solution

Accepted Solutions
ajaykakkar93
Specialist III
Specialist III

hi,

You can use previously-loaded-table / resident load to meet your requirment.

Table1:

Load * inline [

A,B

1,2

3,4

];

Table2:

Load * inline [

A,C

1,F

3,G

];

Table1Final:

A,B

resident Table1;

left join(Table1Final:);

Table2Final:

A,C

resident Table2;

drop table Table2,Table1;

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

View solution in original post

1 Reply
ajaykakkar93
Specialist III
Specialist III

hi,

You can use previously-loaded-table / resident load to meet your requirment.

Table1:

Load * inline [

A,B

1,2

3,4

];

Table2:

Load * inline [

A,C

1,F

3,G

];

Table1Final:

A,B

resident Table1;

left join(Table1Final:);

Table2Final:

A,C

resident Table2;

drop table Table2,Table1;

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting