How to make mapping created field appear at my load script ?

paulyeo11 — Mon, 24 Feb 2020 01:54:29 GMT

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

topic How to make mapping created field appear at my load script ? in QlikView

How to make mapping created field appear at my load script ?