topic Re: Hi in QlikView

Re: Left Join

Mon, 08 Jul 2013 11:35:43 GMT

Hi,

I have four tables like Tab1, Tab2, Tab3, Tab4. The structure is as follows

Tab1:

Load a,b,c

Resident loc;

Tab2:

Load d,e,f

Resident address;

Tab3:

Load g,h,i

Resident orders;

Tab4:

Load j,k,l

Resident Products;

Then

How can i join Tab4 with Tab1 using Left Join in QLIKVIEW?

Can anyone give me the solution for this

Thanks,

Vamsi.

Re: Hi

er_mohit — Mon, 08 Jul 2013 11:37:02 GMT

left join(tablename)

Re: Hi

Mon, 08 Jul 2013 11:38:57 GMT

you can join Tab1 with tab 4,

Tab1:

load * from Tab1;

left join

Tab4:

load * from Tab4;

******************************************

or try this

Tab1:

load * , rowno() as key

from Tab1;

left join

Tab4:

load * ,rowno() as key

from Tab4;

Re: Hi

Mon, 08 Jul 2013 11:41:34 GMT

Examples:

Table1
A	B
1	aa
2	cc
3	ee

Table4
A	C
1	xx
4	yy

QVTable:

load * from table1;

left join

load* from table4;

QVTable
A	B	C
1	aa	xx
2	cc
3	ee

Re: Hi

narender123 — Mon, 08 Jul 2013 11:42:59 GMT

Tab1:

load * from Tab1;

left join(tab1)

Tab4:

load *

from Tab4;

Thanks

Re: Left Join

qlikviewforum — Wed, 23 Apr 2014 09:29:20 GMT

Hi Narender,

May I know which is the left table here. I assume Tab1 is first table here. So all the records from first table will come up.

Please let me know if my understanding it incorrect. So what I understand is Tab1 if the first table and Tab4 is the second table. All the records from the first table will be loaded as it is left join.

Re: Left Join

sudeepkm — Wed, 23 Apr 2014 09:45:52 GMT

In your two tables you have no common fields. So when you do a left join in QlikView then the resulting table will have many records based on combination of each records from first table to the no of records in second table.

Tab1:

Load a,b,c

Resident loc;

Tab4:

Load j,k,l

Resident Products;

the output with sample data can look like below. So please see your data model tables and carefully take a decision for join.