3 Replies Latest reply: Jan 22, 2016 11:06 AM by Sunny Talwar RSS

    Table transfomation



      I have created a little inline table with dates and typs. I know that this example make not really sense but I have a question about this. So what I am trying to do is the following...


      This is the Inline table:


      LOAD * INLINE [

          Date, Typ

          1.1.2015, A

          2.1.2015, A

          1.1.2015, B

          2.1.2015, B



      And now I want to transform the table into this table...

      Typ / Key

      A  / 1.1.2015_2.1.2015_A

      B / 1.1.2015_2.1.2015_B


      How I can do it?