Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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...
This is an example of how to use a crosstable function, I hope it serve you.
Best
Thank you for all who tried to help me and gave me 1 step up.