2 Replies Latest reply: Sep 4, 2013 3:36 AM by BluShadow RSS

    Using data as column names

    Lucky7

      Hi Guys,

       

      The data is like in the format below:

      Item IDCOMMPLACRVESTB_ID
      1Q4-2013Q4-20133
      2Q4-2013Q4-20133
      12Q3-2013Q3-2013Q4-20133

       

      The requirement is to group the data by establishment id and the no of items commissioned, planned, revised and actual in a quarter.

       

      The result set should be like:

       

      ESTB_IDItem IDPL Q3-2013AC Q3-2013RV Q3-2013PL Q4-2013AC Q4-2013RV Q4-2013
      31000101
      32000101
      312100010

       

      What is the best way of achieving this result?

       

      Thanks