Script work fine but when move to Partial reload section i get error ?

[paulyeo11]

Hi All

I have below script work fine on rEVENUE8:-

Concatenate
LOAD
'PMC' as SOURCE,
[Account Code] as GL_CODE,
If([Account Code]>=5000000 and [Account Code]<=5999999,'rEVENUE_8') as [rEVENUE_8],

FROM
[C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\RAW DATA SAP\GL_PMC_2019.xlsx]
(ooxml, embedded labels, table is [Modified GL Data]);

I need to move the script to partial reload script below :-

TABLE_P:
left keep (GL_TABLE)
load [Reporting Code],[Account Code],
If([Account Code]>=5000000 and [Account Code]<=5999999,'rEVENUE_8') as [rEVENUE_9],

resident GL_TABLE;

I get error msg below :-

Field not found - <Account Code>
TABLE_P:
left keep (GL_TABLE)
load [Reporting Code],[Account Code],
If([Account Code]>=5000000 and [Account Code]<=5999999,'rEVENUE_8') as [rEVENUE_9],

Can some one advise me where go wrong ?

Paul

[paulyeo11]

Hi All

i have create a new field with out space , that is AccountCode , and it work fine now. With error , but it produce the wrong result. So it is still not working

paul

[paulyeo11]

Hi All

I create below cost at GL Table load script :-

[Account Code] as AccountCode,

If([Account Code]>=5000000 and [Account Code]<=5999999,'P_Revenue') as [P_Revenue],

Above script work fine. But i need to move to Partial load script section :-

If([AccountCode]>=5000000 and [AccountCode]<=5999999,'P_Revenue_') as [P_Revenue_],

Above script return wrong value.

Hope some one can share with me where go wrong ?

Paul

I just notice now with out error msg , the partial load script below is not return the correct right value :-

If([AccountCode]>=5000000 and [AccountCode]<=5999999,'P_Revenue_') as [P_Revenue_],