Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to join this table?

Hi all im totally new in QV.

Well i have 2 table. I need to join them.
tables are


table1:
load * inline [
country, express
AT, 2
DK, 2
GB, 3
GR, 4
....
];
table2:
load * inline [
weight, zone1, zone2, zone3
0.5, 6, 8, 10
1, 7, 9, 11
1.5, 8, 10, 12
2, 10, 12, 14
.....
];


table1 contains country and their zone codes.
table 2 contains costs of zones and weights.

I need to match zones and join them. How to do this? Need some help please.

12 Replies
pgalvezt
Specialist
Specialist

Hi Munch.

First you don´t need to create a primary key, because Qlikview uses an associative technology. So you just join the tables using the same name in both tables (CONCATENATE). And your case I think you would have to use a Crosstable functon. There is an example around this forum. Let me see if I find the document and I will attach here.

Best...

pgalvezt
Specialist
Specialist

This is an example of how to use a crosstable function, I hope it serve you.

Best

Not applicable
Author

Thank you for all who tried to help me and gave me 1 step up.