1 Reply Latest reply: Aug 25, 2011 9:37 AM by Klaus Skalts RSS

    How to join these following table

    sandeepa rout

      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.

        • How to join these following table
          Klaus Skalts

          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