How to create partial laod a field for Year_n_ ?

[paulyeo11]

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