Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
AK
Thanks. Done
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.
Hi Peter,
I tried, Not working this Applymap in my qvw.
Please find the attached qvw and Xls.
Regards,
AK
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
Thanks. Done