Partial reload script unable to generate Rev

[paulyeo11]

Hi All

(A) Load Script , REV field is working fine :-

Concatenate
LOAD
'PMC' as SOURCE,
[GL Code] as GL_CODE_,
If([GL Code]>=5000001 and [GL Code]<=5000999,'REV') as [REV],
[Credit(LC)]
FROM
[C:\Users\pauly\Dropbox\5 QV_Final\QV_RAW\GL_PMC_2020.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

(B) Partial rload script , REV1 field is not working :-

TABLE_P:
left keep (GL_TABLE)
load [Reporting Code],GL_CODE_,
If([GL_CODE_]>=5000001 and [GL_CODE_]<=5000999,'REV1') as [REV1],
If([Reporting Code]>=100 and [Reporting Code]<=375,'eXP') as [eXP]
resident GL_TABLE;

Can some one advise me where go wrong ?

Pul Yeo

[paulyeo11]

Enclosed my script