My partial reload cannot load 2 field

paulyeo11 — Wed, 22 Apr 2020 11:25:21 GMT

Hi All

i Have 2 partial load script

Part (1) work fine :-

TABLE_P:
left keep (GL_TABLE)
load GL_CODE_,

If([GL_CODE_]>=5000001 and [GL_CODE_]<=5999999,'rEVENUE_P') as [rEVENUE_P],
If([GL_CODE_]>=9400020 and [GL_CODE_]<=9400020,'eXP_TAX_P') as [eXP_TAX_P]

resident GL_TABLE;

Part (2) Not working ( After i load [Reporting Code] field name )

TABLE_P:
left keep (GL_TABLE)
load GL_CODE_,[Reporting Code],

If([GL_CODE_]>=5000001 and [GL_CODE_]<=5999999,'rEVENUE_P') as [rEVENUE_P],
If([GL_CODE_]>=9400020 and [GL_CODE_]<=9400020,'eXP_TAX_P') as [eXP_TAX_P]

resident GL_TABLE;

May i know how to solve it ? if i still need to load 2 field.

Part 2 Script , now working data model :-

Part (1) Script data model Below is working fine :-

enclosed my QVW which is working fine , but i need to add one more field Reporting Code at partial load.

Hope some one can advise me where go wrong ?

Paul

topic My partial reload cannot load 2 field in QlikView

My partial reload cannot load 2 field