topic Re: how to join to tables from different data sources in QlikView

how to join to tables from different data sources

Thu, 25 Oct 2012 12:51:11 GMT

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

Re: how to join to tables from different data sources

Gysbert_Wassenaar — Thu, 25 Oct 2012 13:03:47 GMT

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

Re: how to join to tables from different data sources

Thu, 25 Oct 2012 13:10:14 GMT

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

Re: how to join to tables from different data sources

Thu, 25 Oct 2012 13:10:19 GMT

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

Re: how to join to tables from different data sources

Gysbert_Wassenaar — Thu, 25 Oct 2012 13:16:47 GMT

same difference

Re: how to join to tables from different data sources

Thu, 25 Oct 2012 13:22:04 GMT

Hi it doesn't work though.

where should i be putting the left join?

Re: how to join to tables from different data sources

Thu, 25 Oct 2012 13:28:27 GMT

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?

Re: how to join to tables from different data sources

Thu, 25 Oct 2012 13:28:33 GMT

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?