Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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