8 Replies Latest reply: Jul 4, 2012 1:13 PM by Joe Kirwan RSS

    Crosstable load: problem with dates in columns

    Joe Kirwan

      i have created a crosstable load for March data as follows:

       

      CrossTable(PayDate, Qty, 3)LOAD [Class type],
          
      Item,
          
      Price,
          
      [01/03/2012],
          
      [02/03/2012],
          
      [03/03/2012],
          
      [04/03/2012],
          
      [05/03/2012],
          
      [06/03/2012],
          
      [07/03/2012],
          
      [08/03/2012],
          
      [09/03/2012],
          
      [10/03/2012],
          
      [11/03/2012],
          
      [12/03/2012],
          
      [13/03/2012],
          
      [14/03/2012],
          
      [15/03/2012],
          
      [16/03/2012],
          
      [17/03/2012],
          
      [18/03/2012],
          
      [19/03/2012],
          
      [20/03/2012],
          
      [21/03/2012],
          
      [22/03/2012],
          
      [23/03/2012],
          
      [24/03/2012],
          
      [25/03/2012],
          
      [26/03/2012],
          
      [27/03/2012],
          
      [28/03/2012],
          
      [29/03/2012],
          
      [30/03/2012],
          
      [31/03/2012]

          FROM
      [E:\Test.xls]
      (
      biff, embedded labels, table is detail$)
      where len(Item)>0;

       

      Question 1 - How do I get the dates to load as values?

       

      Question 2 - I want to be able to save the April file under the same name into the same directory. Can anyone suggest how I could change my script to be able to load the data for each day of the month irrespective of whether the month has 28,29,30 or 31 dates (and therefore columns).. (Note there is always a Total column to th eimemdiate right of the last column in each month.

       

      Rgds

       

      Joe