7 Replies Latest reply: May 23, 2013 5:16 PM by David Dumas RSS

    use of a pick() in a load script to substitute month name

      I have source data, which does not have a date, only a month number and year.

       

      I created an inline table:

       

      Month_Sort:

      Load * Inline [

      RA_Month, MthSortOrder

      Jan,1

      Feb,2

      Mar,3

      Apr,4

      May,5

      Jun,6

      Jul,7

      Aug,8

      Sep,9

      Oct,10

      Nov,11

      Dec,12

      ];

       

      .... and then in my transactions load, did this:

       

       

      pick(MonthNumber,

      'Jan',

      'Feb',

      'Mar',

      'Apr',

      'May',

      'Jun',

      'Jul',

      'Aug',

      'Sep',

      'Oct',

      'Nov',

      'Dec'

      ) as RA_Month

       

       

      It works, but is there a better way?