Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

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

2 Replies
paulyeo11
Master
Master
Author

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
Master
Master
Author

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_],