2 Replies Latest reply: Jan 27, 2014 12:39 PM by Antoine Frangieh RSS

    Computing from 2 tables

      I have a 'Month' field and a 'Date' field in one load table and various values for each of the 12 months in another load table. I want to get the value from this table based on the 'Date' field

       

      LOAD

      ...

      Month,

      Date

      ....

       

       

      ;

       

      LOAD

      ...

      Jan_value,

      Feb_value,

      ...

      ;

      I want to do something like

      LOAD

      if (Month = 1, Jan_value, if (Month = 2, Feb_value,....)

      ;

      Can you suggest a way of doing this?

       

      Thanks