Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

Why partial reload only allow me add 1 field ? load GL_CODE_,R_CODE, is not allow

Hi All

I have below load script , it work fine , but when i add only field GL_CODE_ , it work fine , but when i add one more field R_CODE_, at partial reload , it just dont generate the variable rEVENUE_P and rEVENUE_T. if i remove R_CODE_ , it will generate rEVENUE_P.

GL_TABLE:
LOAD
'P' AS SOURCE,
GL_CODE AS GL_CODE_,
AMOUNT
FROM
GL_P.xlsx
(ooxml, embedded labels, table is Sheet1);

Concatenate

LOAD
'T' AS SOURCE,
R_CODE,
AMOUNT
FROM
GL_P.xlsx
(ooxml, embedded labels, table is Sheet2);

TABLE_P:
left keep (GL_TABLE)
load GL_CODE_,R_CODE,

If([GL_CODE_]>=1 and [GL_CODE_]<=2,'rEVENUE_P') as [rEVENUE_P],
If([R_CODE]>=1 and [R_CODE]<=2,'rEVENUE_T') as [rEVENUE_T]

resident GL_TABLE;

Hope some one can advise me , what are the work around solution.

Paul

1 Reply
Highlighted
Master
Master

Enclosed my raw data and QVW