0 Replies Latest reply: Sep 18, 2015 1:22 AM by Yeo Poh sai RSS

    How to create partial laod a field for Year_n_ ?

    Yeo Poh sai

      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 ?