How to make mapping created field appear at my load script ?
Hi All
below is my load script :-
GL_TABLE: LOAD 'TDS' as SOURCE, @1:16T as GL_CODE_, ApplyMap('MAP_TDS',@1:16T,'OTHERS') as [REV] FROM FS_TDS_.TXT (ansi, fix, no labels, header is 0, record is line);
MAP_TDS: LOAD GL_CODE_, PNL_TYPE FROM [Map_PNL_.xlsx] (ooxml, embedded labels, table is TDS);
GL_TABLE: LOAD 'TDS' as SOURCE, @1:16T as GL_CODE_, ApplyMap('MAP_TDS',@1:16T,'OTHERS') as [REV] FROM FS_TDS_.TXT (ansi, fix, no labels, header is 0, record is line);