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

[paulyeo11]

Hi Sir

Thank you for your sharing . now 4:12 Am i am go back to sleep.

Paul

[kaushiknsolanki]

Sure,

Have a sound sleep.

Good to know that you are awake to learn something new. 🙂

[paulyeo11]

Hi Sir

Now every thing work fine now. So need to break down all the script and understand .

Paul