topic Re: Replace the number values using the mapping table. in QlikView

Replace the number values using the mapping table.

govind1501 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Replace the number values using the mapping table.

Taoufiq_Zarra — Tue, 07 Jul 2020 09:08:31 GMT

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 :

Re: Replace the number values using the mapping table.

govind1501 — Tue, 07 Jul 2020 09:21:39 GMT

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