Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to recode using mapping

Hi All,

(A) Below is GL Tabe for TDS :-

SOURCE       GL_CODE_
TDS                 80020

(B) Below is GL Tabe for PMC :-

SOURCE       GL_CODE_
PMC               5000200

(c) I Like to make the table become like below :-

SOURCE      GL_CODE_                   GL_CODE_NEW
PMC              5000200                        REVENUE
TDS               80020                             REVENUE

(D) i Have try below load script :-

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. 

Paul

 

 

 

1 Reply
paulyeo11
Master
Master
Author

Enclosed my ZIP file consists of QVW and Raw data.