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

paulyeo11 — Thu, 23 Apr 2020 02:36:17 GMT

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

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

paulyeo11 — Thu, 23 Apr 2020 02:37:15 GMT

Enclosed my raw data and QVW

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

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

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