1 Reply Latest reply: Jul 24, 2013 5:06 PM by Miguel Angel Baeyens de Arce RSS

    How to transpose values from a table and group them by a field?

      Hello,

       

      This might be too easy to put on the forum but I'm in a bit of a rush. Would be grateful for a helping hand.

      I've got a table such as this:

       

       

      NameA
      BC
      Jack50100150
      Jill255075

       

      I need to transform this table at load time to look like this:

       

       

      Name
      ValueType
      Jack50A
      Jack100B
      Jack150C
      Jill25A
      Jill50B
      Jill75C

       

       

      Here's the inline code for the input table:

       

      Table1:

      Load * inline [

      Name,A,B,C

      Jack,50,100,150

      Jill,25,50,75

      ];

       

       

       

      Thank you, guys!

      Sam.