topic Re: Replace Value field from Script in QlikView

Replace Value field from Script

sona_sa — Mon, 27 Aug 2018 08:50:47 GMT

Hi All,

In this attached qvw, I have to replace the Value field, Where ever T-Mobile, T-Mobile US, T-Mobile D is available, I want to replece the same value with only T-Mobile.

Similary for Vodafone and TMO.

Please find the attached QVW.

Thanks

Re: Replace Value field from Script

prieper — Mon, 27 Aug 2018 09:07:18 GMT

Hi,

think that it is easier to work with a mapping table:

mapCustomer:

MAPPING LOAD * INLINE [read, write

T-Mobile, T-Mobile

T-Mobile US, T-Mobile

T-Mobile D, T-Mobile];

Data:

LOAD

APPLYMAP('mapCustomer', Customer) AS Customer_mapped

FROM

.....;

APPLYMAP will translate only the listed entries. Others will be show unchanged.

HTH

Peter

Edith would like to add that the mapping may also be loaded from an external table, like Excel - thus easy to maintain.

Re: Replace Value field from Script

sona_sa — Mon, 27 Aug 2018 09:34:06 GMT

Hi Peter,

I tried, Not working this Applymap in my qvw.

Please find the attached qvw and Xls.

Regards,

Re: Replace Value field from Script

prieper — Mon, 27 Aug 2018 10:59:39 GMT

Hi,

might be worth to question the datamodel,

anyhow:

load the mapping, as needed (and add all the VODAFONE etc) and put in line 79 as line like

If([Final Field] = 'OPERATOR', APPLYMAP('mapCustomer', Value)) AS NewField1

should then do

Peter

Re: Replace Value field from Script

sona_sa — Mon, 27 Aug 2018 12:25:08 GMT

Thanks. Done