How to join this table?

[#1]

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.

[pgalvezt]

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]

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

Best

[#4]

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