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);
It created below table :-
SOURCE .......GL_CODE_ ............REV
TDS ..............80020 .....................-
I add mapping load script :-
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);
I get below table :-
SOURCE ......GL_CODE_.... REV .............PNL_TYPE
TDS .............80020 ...........NIL ...............REVENUE
How to make the display display as below ?
SOURCE........ GL_CODE_ ..........REV ...........PNL_TYPE
TDS ................80020 ..................REVENUE .......NIL
Can some one advise me.
Paul