topic Joins in QlikView

Joins

Tue, 19 Apr 2011 14:02:26 GMT

hi,

I am Kumar

I have 2 tables(those are Excel data)

Products:

Address	City	Fname	Lname	P_id
aavdvv	dfdvn	ola	Hansen	1
dbhg	fgeew	ccccccc	dddd	2
dvcd	dgghg	bbbbbb	aaaa	3

Orders:

O_id	O_no	P_id
1	234	4
2	345	3
3	456	1
4	678	1
5	898	2

These are the examle tables i have taken..

and how the differant types of joines are applied in Qlikview.In detailed.....

Joins

ashfaq_haseeb — Tue, 19 Apr 2011 14:14:56 GMT

Hi Ravi

Just go through the Document attached.

Hope that helps.

Regards

ASHFAQ

Joins

Tue, 19 Apr 2011 14:19:20 GMT

hello

You will find about join types in QV Help(F1). It's with example and easy to understand.

Joins

Miguel_Angel_Baeyens — Tue, 19 Apr 2011 15:00:30 GMT

Hello,

First of all, QlikView's associative logic would say that if you have two tables with a field named alike with the same value (call it a Key field) tables are associated by those fields.

Meaning that if, according to your example above, you want to know the value of "O_no" for Address "dbhg" you don't need to do any additional joining, tables are linked automatically by their "P_id" field.

So in my case, without further requirements, I'd leave your tables as you already have it.

Hope that helps.