1 Reply Latest reply: Jan 25, 2012 6:25 AM by jagan mohan rao appala RSS

    Item property in several column

    Vilius Sasnauskas

      Hello,

      Can help me. I have 2 table:

      1-Item (field Item No_),

       

      Item No_
      A1
      A2
      A3
      A4

       

      2-Item Property (Item No_,Property No_).

      Item No_Property No_
      A1P1
      A2P2
      A3P3
      A4P4
      A2P2
      A2P4
      A3P1
      A3P4
      A4P3

       

      Fields look like in qlikview I want to see this:

      Item No_Property No_1Property No_2Property No_3Property No_4
      A1P1P2P3P4
      A2P2P4--
      A3P1P3--
      A4P3---


      Its like hierarchy , but not exactly