2 Replies Latest reply: Jun 27, 2013 8:23 PM by Vishal Jada RSS

    Interesting QlikView data manipulation challenge

    Vishal Jada

      Hi fellow Qlikview devlopers,

       

      I have intersting data manipulation challenge. I have simple column where data is broken in the following manner (table 1)

       

      Table1:

      Column1
      A
      B
      C
      A
      B
      A

       

      I have to take table 1 and insert a new row above everytime i see the value A. The position of this new inserted row is very important (table 2).

       

      Table2:

      Column1
      A
      B
      C
      A
      B
      A

       

      Please advise.

       

      Thanks for your time.

       

      Regards


      Thomas.