I need to recode GL_CODE 80020 to REVENUE , i get error

[paulyeo11]

Hi All

I create below step for above mentioned :-

GL TDS Tab ::-

ApplyMap('MapGL',@1:16T,'OTHERS') as [GL_C9],

Map GL Tab :-

MapGL:
Mapping LOAD
[GL_CODE8],
[GL_CODE9]
FROM MapGL.xlsx (ooxml,embedded labels, table is [GL]);

I create a excel file Tab name GL :-

GL_CODE8 GL_CODE9
80020 REVENUE

I get below error :-

MapGL:
Mapping LOAD
[GL_CODE8],
[GL_CODE9]
FROM MapGL.xlsx (ooxml,embedded labels, table is [GL])

Paul

[Arthur_Fong · Accepted solution]

Try inserting '' for all columns that contains special characters:

@1:16T >> '@1:16T'

@58:77T>>'@58:77T'

@124:129T>>'@124:129T' etc

[paulyeo11]

Thank you very much for your sharing .