4 Replies Latest reply: Jun 21, 2013 3:47 AM by Vishwaranjan Kumar RSS

    Transform fieldvalue to fieldname

      Hello,
      I need to transform a table. The values in the column "name" should become columns and the corresponding values in the column "value" should become the values of the newly created column.
      Example:
      from:
      KEYnamevalue
      VOR-63dringlichkeitmittel
      VOR-63enddatum31.12.2013
      VOR-63grösseHoch
      VOR-63kontextHIN
      to:
      KEYdringlichkeitenddatumgrössekontext
      VOR-63mittel31.12.2013HochHIN

       

      any ideas?

       

      thanks,

      Marcel