0 Replies Latest reply: Sep 18, 2015 1:22 AM by PAUL YEO RSS

    How to create partial laod a field for Year_n_ ?

    PAUL YEO

      Hi All

       

       

      I want the Year_n now working fine , but not in partial load script .

       

       

      year(today()) - year(@50:60T) + 1                                         as Year_n,

       

       

       

       

      So i create a partial load script below :-

       

       

      left join    (sales)

         

      Load desc,

       

       

      year(today()) - year(date) + 1  as Year_n_

       

       

      Resident sales group by desc;

       

       

      I get error massage.

       

       

      Hope some one can tell me where i go wrong ?

       

       

       

       

      Paul