Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to join to tables from different data sources

Hi,

i have 2 connections in my Qlikview dashboard. 1 table called orders with an id field and other table with customer information from another data source pulling field in.

i want to join them on the id field where it only pulls data from the customer table if the id is present in the orders table, i know you can alais the field to give them a full join but that is not what i want.

any help appreciated.

thanks

laura

7 Replies
Gysbert_Wassenaar

You could do something like this:

Table1:

LOAD *;

SELECT <your query 1>;

JOIN (Table1)

LOAD * WHERE EXISTS (id);

SELECT * FROM Table2;

However, that will still fetch all the records from Table2. There's no easy way around it I'm afraid (or at least one that doesn't break easily).


talk is cheap, supply exceeds demand
Not applicable
Author

the tables are from 2 different databases. so it looks like

Connect to database a

Table1:

LOAD *;

SELECT <your query 1>;

Connect to database

LOAD *;

SELECT <your query 2>;

Not applicable
Author

the tables are from 2 different databases. so it looks like

Connect to database a

Table1:

LOAD *;

SELECT <your query 1>;

Connect to database

LOAD *;

SELECT <your query 2>;

Gysbert_Wassenaar

same difference


talk is cheap, supply exceeds demand
Not applicable
Author

Hi it doesn't work though.

where should i be putting the left join?

Not applicable
Author

to be more specific it looks like

ODBC Connect xxx

orders:

load  aaa, bbb  , cccc;

sql select aaa, bbb,ccc

from abc

odbc connect xxxx

load  aaa, dddd  , eeee;

sql select aaa, ddd,ceee

from dbe

i want to join aaa in orders to aaa in the other table, i want want aaa in the other table where there is an aaa which matches in orders?

Not applicable
Author

to be more specific it looks like

ODBC Connect xxx

orders:

load  aaa, bbb  , cccc;

sql select aaa, bbb,ccc

from abc

odbc connect xxxx

load  aaa, dddd  , eeee;

sql select aaa, ddd,ceee

from dbe

i want to join aaa in orders to aaa in the other table, i want want aaa in the other table where there is an aaa which matches in orders?