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

    Table transfomation

    Hans Müller

      Hey,

       

      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:

      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?