4 Replies Latest reply: Apr 24, 2017 11:35 PM by Shivani Singhal RSS

    num(Dual(F1, Match(F1, 'Jan', 'Feb', 'Mar'))) as F3  ??

    Shivani Singhal

      A:

      LOAD * INLINE [

          F1, F2

          Jan, 10000

          Feb, 20000

          Mar, 30000

      ];

       

       

      NoConcatenate

      B:

      Load F2,

        F1,

        num(Dual(F1, Match(F1, 'Jan', 'Feb', 'Mar'))) as F3  // what does this expression mean..

        Resident A;

        DROP Table A;