Replace the number values using the mapping table.

[govind1501]

Hi All,

I have the tables like below and required replace values in EMPVALUE using POSTDESC and  please find expected output below.

EMPID	EMPVALUE
101A	001002
102A	002003
103A	003001

POSTID	POSTDESC
001	High
002	Low
003	Med

Expected Output:

EMPID	EMPVALUE
101A	HighLow
102A	LowMed
103A	MedHigh

[Taoufiq_Zarra · Accepted solution]

Hi,

One Solution:

Map1:
Mapping LOAD * INLINE [
    POSTID, POSTDESC
    001, High
    002, Low
    003, Med
];


Data:
LOAD *,MapSubString('Map1', EMPVALUE) as New_EMPVALUE  INLINE [
    EMPID, EMPVALUE
    101A, 001002
    102A, 002003
    103A, 003001
];

output :

[govind1501]

Working perfect Toufiq. Accept as your solution. thank you.