How to join these following table

[#1]

Hi All,

How to join these two tables in qlikview?

Table1:

A_personcode	A_orgcode	A_orgname	A_orgtype
1	1	xxx	mnc
1	2	yyy	mnc
4	3	zzz	mnc

Table2:

B_personcode	B_orgcode	B_orgname	B_orgtype
1	1	xxx	mnc
2	5	aaa	mnc
2	7	bbb	mnc
4	3	zzz	mnc
4	8	ccc	mnc

Please Note:

one personcode can associate with more than orgcode.

Many Thanks.

[klausskalts · Accepted solution]

And the result should be a record layout like this:

Personcode

Orgcode

Orgname

Orgtype

ORG:

Load

     A_personcode as Personcode,

     A_orgcode as Orgcode,

     A_orgname as Orgname,

     A_orgtype as Orgtype

from Source_A:

Join (ORG) Load

     B_personcode as Personcode,

     B_orgcode as Orgcode,

     B_orgname as Orgname,

     B_orgtype as Orgtype

from Source_B:

// Klaus