3 Replies Latest reply: Jun 25, 2014 10:06 AM by Gysbert Wassenaar RSS

    Complicated crosstable

      Hi Community,

       

      I have a slightly hard cross table transformation that I need to do.

      Lets say I have the below table:

       

      IDFieldA.1FieldA.2FieldA.3FieldB.1FieldB.2FieldC.1
      1abcrty

       

      And I want to transpose that to:

       

      IDCaseField1Field2Field3
      1Aabc
      1Brt
      1Cy

       

      Is that possible in any kind of way?

      Take into account that the number of Columns in each case are not fixed so I can have case 1 with 10 fields and case B with 1.

       

      Any help appreciated.