Learn Apply Map

[paulyeo11]

Hi All

I try to learn how to apply mapping .

May i know why cannot add MAPPING in below script ?

MAP:
//MAPPING
LOAD
SEG_RAW,
SEGMENT
FROM
C:\Users\pauly\Dropbox\mainqv\QV_PROJECT\MAPPING\MAPPAY.xlsx
(ooxml, embedded labels, table is ADL);

PAY:
LOAD
UserField1,
ApplyMap('Map_PAY',[UserField1],'OTHERS') as [SEGMENT_]
FROM
C:\Users\pauly\Dropbox\mainqv\QV_PROJECT\MAPPING\PAY_ADL.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Paul

[kaushiknsolanki]

Hi,

It is working for me. See the attached file.

[kaushiknsolanki]

When you remove it, it is just like a normal association.

If you want to try, do this. Change the field name in Pay Table from UserField1 to UserField2.

When you do this, it wont show you the proper result.

[paulyeo11]

Hi Sir

when i download the QVW file you send me , it work fine now.

Now when i try to comment Mapping , it does not work .

But if i try my own script , it still not working.

Paul

[kaushiknsolanki]

That should not happen. What version you are having?

[paulyeo11]

Ver 9

[kaushiknsolanki]

What..?

Qlikview version 9? 

Are you sure?

[paulyeo11]

Yes i have been using this ver 9 and i never have any issue in the past , only recently i enclosed this issue.

[paulyeo11]

Hi Sir

when you press control T , do you see only one table with 2 field ?

Paul

[kaushiknsolanki]

Thats true,

because the mapping table stays in RAM till script execution is going on. Once script is finished the Mapping table is flushed out of RAM.

[paulyeo11]

Hi Sir

If i have 5 different company segment table.

should i using one mapping table for 5 company ?  

because i need each company have it own recode.

Paul