topic How to join these following table in QlikView

How to join these following table

Thu, 25 Aug 2011 11:57:25 GMT

Hi All,

How to join these two tables in qlikview?

Table1:

Table2:

Please Note:

one personcode can associate with more than orgcode.

Many Thanks.

klausskalts — Thu, 25 Aug 2011 13:37:51 GMT

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