topic How to join this table? in QlikView

How to join this table?

Fri, 04 Mar 2011 10:15:06 GMT

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.

How to join this table?

Fri, 04 Mar 2011 10:20:23 GMT

Hi Muncho,


table1:
load * inline [
country, express
AT, 2
DK, 2
GB, 3
GR, 4
....
];

//table2:
join load * inline [
weight, zone1, zone2, zone3
0.5, 6, 8, 10
1, 7, 9, 11
1.5, 8, 10, 12
2, 10, 12, 14
.....
];

simply use join between the tables. if u want left join r right join just mention it. in qlikview join are very easy.

AW:How to join this table?

brenner_martina — Fri, 04 Mar 2011 10:21:19 GMT

Hi,

I can not see, what is you key to join the tables?

Normally it goes like this:

Table1:
Load key, field1, field2, ... from table1;

Left Join (Table1)
Load key, field3, field4,... from table2;

How to join this table?

Fri, 04 Mar 2011 10:35:07 GMT

Hi Srividhya

In express field there is zone codes inside.
In zone1, zone2, zone3 fields of table2 are cost.
So i think just joining them is cannot solve this.

Regards

AW:How to join this table?

Fri, 04 Mar 2011 10:38:52 GMT

Hi Martina.

I know i need key fields to join them. That's why i posted.
Need some help to make key.

How to join this table?

Fri, 04 Mar 2011 10:42:43 GMT

Hi Muncho,

I need to match zones and join them. means...... realy am nt getting u.... plz exp clr wat's ur need

How to join this table?

Fri, 04 Mar 2011 10:45:42 GMT

PFA .... Is this wat u want.. may right

How to join this table?

Fri, 04 Mar 2011 10:59:50 GMT

Well i use example to describe it to you.

If i select GB their zone code is 3 in table1.
so i need to show just weight and cost of zone3 in table2. I think i need to change something in table2. But how? that's what im asking.
these 2 tables from excel file. This excel file may change sometimes so i dont want to change or edit in excel file.

Do you got me now?

How to join this table?

Fri, 04 Mar 2011 11:21:11 GMT

Try using the inline wizard and selecting cross table, that should change the structure from

weight, zone1, zone2, zone3
0.5, 6, 8, 10
to

weight, zone, cost

0.5, zone1, 6

0.5, zone2, 8

0.5, zone3, 10

Also you need to change the name "express" in table1 to "zone" and make sure the text matches the zone descriptions in table2, so that the 2 tables match.

table1a:load

country,

'zone'&express as zone

resident table1

Then drop table1.

How to join this table?

Fri, 04 Mar 2011 11:58:57 GMT

hello rick

QV is totally new to me. And i got something on your post. But i have no idea how to use that crosstable. Can you give me some example.

How to join this table?

pgalvezt — Fri, 04 Mar 2011 14:13:41 GMT

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...

How to join this table?

pgalvezt — Fri, 04 Mar 2011 16:24:54 GMT

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

Best

How to join this table?

Fri, 04 Mar 2011 20:28:05 GMT

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