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
