topic Combining two DataSources in QlikView

Combining two DataSources

Wed, 15 Jun 2011 17:42:04 GMT

Hi, I'm new to QlikView and i have the following question:

I have two connections, to 2 different databases

For example

CONNECT TO DB1

AA: Select A,B,C from table1;

CONNECT TO DB2

BB: Select D,E,F from table2;

I dont know how to use fields from table 1 into a new query combining fields from table2

Somenthing like..:

Select * from AA,BB where AA.A like BB.E;

Thanks for the help

Frank

Re: Combining two DataSources

Wed, 15 Jun 2011 18:19:51 GMT

You typically use one field that links tables from both sources (a foreign and primary key?), and give these the exact same fieldname in QV. So if column A from table1 actually refers to column E from table2 you would get:

TABLE1:

CONNECT TO DB1;

SELECT A as key, B, C from table1;

TABLE2:

CONNECT DB2;

SELECT D, E as key, F from table2;

The joining of the tables works automatic when you combine attributes from both tables in one chart.

Combining two DataSources

Wed, 15 Jun 2011 18:40:00 GMT

Thanks for your answer

I'm aware of "automatic" join when fields have same name.

But i need something else.

I have two ListBoxs

LIST1 LIST2

A CAT

B DOG

C HAT

So what i need is to filter LIST2 by finding values from LIST1.

For example if I select "A" it should bring CAT and HAT. I need something like a "LIKE" statement, so that's why a simple join isn't enoguht.

Thanks for your help