5 Replies Latest reply: Feb 6, 2015 11:40 AM by neetha P RSS

    Transpose a table ?

    Laura Sébille

      Hello everyone,

       

      I have a table AAA like this :

       

      ID              Status                timestamp

      XX1               A                    10/10/2015   04:00:15

      XX1               B                    11/10/2015   04:20:15

      XX1               C                    11/10/2015   22:00:15

      XX2               A                    14/11/2015   23:00:12

      XX2               C                    15/11/2015   23:07:18

       

       

       

      And I would like a table BBB like this :

       

      ID                             A                                             B                                      C

      XX1           10/10/2015   04:00:15           11/10/2015   04:20:15         11/10/2015   22:00:15

      XX2           14/11/2015   23:00:12                           -                           15/11/2015   23:07:18

       

       

       

      How can I do it ? I have heard about the crosstable load function but I think it is more to do it on the other way ? (from the AAA table to the BBB table)

       

      Any ideas ?

       

      Thank you

       

      Have a good day

      Laura