2 Replies Latest reply: Mar 6, 2014 7:56 PM by Udip Shrestha RSS

    modifying QVD

      Hello All,

       

      I have a question and this might be really simple, but here goes anyway:

      I have a table which is like:

      ID     CO

      01     A

      02     A

      03     A

      01     B

      04     B

      03     C

      04     C

       

      So I want to create a QVD which will show

      OriginalID     OtherID

           01               02

           01               03

           01               04

           02               01

           02               03

           03               01

           03               02

           03               04

           04               01

           04               03

      So if the ID has common CO, they should represent each other in OriginalID fields.

       

      Any ideas anyone?

       

      Thanks