Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Re: Left Join

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.

6 Replies
er_mohit
Master II
Master II

left join(tablename)

Not applicable

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;

Not applicable

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

narender123
Specialist
Specialist

Tab1:

load * from Tab1;

left join(tab1)

Tab4:

load *

from Tab4;

Thanks

qlikviewforum
Creator II
Creator II

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.

sudeepkm
Specialist III
Specialist III

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.

T86313.png