Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to join these following table

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.

1 Solution

Accepted Solutions
klausskalts
Contributor

How to join these following table

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

1 Reply
klausskalts
Contributor

How to join these following table

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

Community Browser