Joining two tables and getting the right data

Fri, 05 Jun 2009 14:00:26 GMT

Hi Fellow users,

I have two tables I would like two join. Material table and Labor table. Here is an example what goes wrong.

Table Material

Table Labor

job	Name	Hours	Period
08w3000	John	27	1

When I join the Material table with the Labor table I get the following result:

So when I a make a graph table I get the correct amount but the hours are (3*27)= 81hours.

Could someone help me with this problem, how can I create the following table

Regards,

Aissam

Fri, 05 Jun 2009 14:13:46 GMT

Hi,

You r right, joins work in that way as you defined.

to get your desired out put table , you should concatenate both the tables.

[Table Material] :

Load --------

-------

From Table_Material;

Concatenate

[Table Labor] :

Load --------

-------

From Table_Labor;

Hope so this will help you !

- Sridhar

topic Joining two tables and getting the right data in QlikView