2 Replies Latest reply: Aug 15, 2012 8:35 AM by lukegeorge RSS

    Best Way to Structure Data Load in Script

      Hi,

       

      I have a table which is arranged as,

       

      FileIDDataIDData

      1

      0001

      01/01/2011

      10002500
      10003Name
      2000105/04/2012
      200021200
      20003Name2
      3000107/06/2010
      30002150
      30003Name3

       

      I'd like to be able to use tables in the application instead of pivot charts so that calculation times are kept low.

       

      I'd like to arrange the table like this,

       

      FileIDDataID=0001DataID=0002
      101/01/2011500
      205/04/20121200
      307/06/2010150

       

      What's the best way of structuring this so that it's formatted this way in the script?

       

      Thanks