7 Replies Latest reply: Jun 17, 2015 4:50 AM by sindhu kannan RSS

    Table rotation in the script

    Benjamin DEMOUSTIER

      Good day,

       

      I have a table as below:

       

      NameTypeCount
      XA1
      XB2
      YA3
      YC4
      ZA5
      ZC6
      ZD7

       

      and I need to have a transposed table generated by the script as below:

       

       

      NameABCD
      X12
      Y3 4
      Z5 6

      7

       

       

      In other word, I need to define, in the script, the name of a field by a formula.

       

      Do you think it's possible ?

       

      Any idea ?

       

      Kind regards