MAP_TDS: LOAD GL_CODE_, GL_CODE_NEW FROM [C:\Users\pauly\Dropbox\5 QV_Final\QV_INPUT\Map_PNL.xlsx] (ooxml, embedded labels, table is TDS);
MAP_PMC: LOAD GL_CODE_, GL_CODE_NEW FROM C:\TEMP\Map_PMC.xlsx (ooxml, embedded labels, table is TDS);
GL_TABLE: LOAD 'TDS' as SOURCE, @1:16T as GL_CODE_, @17:47T as GL_DESC_, if(@102:103T = '-',@86:101T*-1,@86:101T)*-1 as [Amount], ApplyMap('MAP_TDS',@1:16T,'OTHERS') as [REV] FROM C:\TEMP\FS_TDS.TXT (ansi, fix, no labels, header is 0, record is line);
Concatenate LOAD 'PMC' as SOURCE, [GL Code], [GL Code] as GL_CODE_, [GL Description] as GL_DESC_, [C/D] as Amount, ApplyMap('MAP_PMC',[GL Code],'OTHERS') as [REV] FROM [C:\TEMP\GL_PMC.csv](txt, codepage is 1252, embedded labels, delimiter is ',', msq);
It does not work, hope some one can advise me where i go wrong ?
Remark : The reasons I want to using Mapping is because I can reduce the expression at load script , also my actually application I have about 100 GL Code , any change I can modify at excel file.
