Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
left join(tablename)
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;
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 |
Tab1:
load * from Tab1;
left join(tab1)
Tab4:
load *
from Tab4;
Thanks
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.
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.