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
