4 Replies Latest reply: Jan 15, 2014 6:46 AM by Nompumelelo Manzini RSS

    Changing field values

      Hi

      I have load the following table

       

      TASKS:

      CrossTable(CalendarMonth, Value, 4)

      LOAD UNIQUE_ID as TASK_HKEY,

           PARENT_ID,

           TASK_NAME,

           Resource as RESOURCE,

           ACC_MAY as 'May',

           ACC_JUN as 'Jun',

           ACC_JUL as 'Jul',

           ACC_SEP as 'Sep'

      FROM

      [project data 20131029.xlsx]

       

      How can I change the value to be an actual calender month instead of text e.g. 'May'

       

      Thanks

      Mpumi