5 Replies Latest reply: Feb 9, 2015 11:38 AM by ioannis giakoumakis RSS

    Table transformation

    Oleg Granat

      Hi,

      I have a table like this:

      T1:

      LOAD * Inline [

      ID, ITEM

      1, A

      1, B

      1, C

      2, A

      2, F

      ];

      Is there an effective mechanism for the transformation this table into:

      ------------------------------

      ID, ITEMS

      1, "A,B,C"

      2, "A,F"

      -----------------------------

      ?

       

      Thanks in advance,

      Oleg