Join issue

[#1]

Hi,

As a newbie on QlikView I've got in to a challange on joins (I think...). In this case I have two qvd-tables, Company and CompanyInformation. Unfortunately CompanyInformation.qvd conatins more records than I have active companies in the Company.qvd. In my Chart (Pivot Table/Straight Table) I want to show information on records that is present in both tables only.

This is a short example of my case:

Company.qvd contains

Name	Phone	CreatedDate	ClosedDate	fk_CompanyInformationId
A	555-103-000	19.01.2007		1
B	555-103-001	25.08.2003		2
C	555-103-002	30.01.2001		4
D	555-103-003	16.05.2007		5

CompanyInformation.qvd contains

CompanyInformationId	GLN	ContactName
1	7080000000100	Torgersen
2	7080000000120	Rahmanian
3	7080000000125	Evje
4	7080000000178	Jansson
5	7080000000183	Olsen
6	7080000000210	Myrhaug
7	7080000000325	Brunner

And this is what I want to show in my Chart (Pivot Table/Straight Table):

CompanyInformationId	GLN	CompanyName
1	7080000000100	A
2	7080000000120	B
4	7080000000178	C
5	7080000000183	D

Any suggestions?

[CELAMBARASAN · Accepted solution]

Hi,

     Company:

     Load

                Name as CompanyName,

               fk_CompanyInformationId as CompanyInformationId,

     From

          Company.qvd;

Left Join(Company)

     Load

               CompanyInformationId,

               GLN

     From

          CompanyInformation.qvd;

QV automatically joins the table based on the common field name

Hope it helps

CELAMBARASAN

[#3]

Thanks,

That saved my day.