Joining two tables and getting the right data

Fri, 05 Jun 2009 14:00:27 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:14:23 GMT

Hi Aissam,

concatenate will do the job.

Hope it´s the right way so you get the requested results.

Rainer

Fri, 05 Jun 2009 14:22:40 GMT

yes Rainer

Here is the attached sample.

-Raghu

Fri, 05 Jun 2009 15:44:23 GMT

Thanks guys,

It works. I will have a good night sleep :-).

Regards,

Aissam

topic Joining two tables and getting the right data in QlikView