Why partial reload only allow me add 1 field ? load GL_CODE_,R_CODE, is not allow
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);
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]
Hope some one can advise me , what are the work around solution.