My load script work fine , after move to partial reload script it not working ?

[paulyeo11]

Hi All

Why my below partial reload script now work ?

TABLE_P:

left keep (GL_TABLE)

load [Reporting Code],

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

resident GL_TABLE;

When i move to GL Table load script , it work fine :-

Concatenate
LOAD
'PMC' as SOURCE,
[Account Code] as GL_CODE,
[Account Code] as AccountCode,

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

Paul Yeo

[paulyeo11]

My QVW

[dplr-rn]

whats the error ?

[paulyeo11]

Hi Sir

Thank you for your asking.

I have create 2 field , one of the field is from GL Table , Anther field is create from Partial load script.

When reload I don’t get any error.

When I use the 2 field to generate the report . The field that generate using partial reload does not give the correct vakue in Table . Where the field created from GL Table give the correct table value in table.

I have QVW file , there are 2 button , one is show the correct sales value , another button when click does not show the correct value in table.

Paul

[paulyeo11]

Hi All

Below is my QVW

paul