field value

[qlikviewaf]

Hi guys,

there's a way after that all values have been loaded from the script to rename a field value?

for examplle i have a field called "Region" i would like to rename only for that field all values EMEA into E-M-E-A,

how can i do this?

Thanks!

[Anil_Babu_Samineni]

May be this?

If(Match(Region, 'EMEA'), 'E-M-E-A', Region) as Region

[its_anandrjs]

I suggest you to do the Data cleansing on the table below is the example to explain this by the help of the Mapping load see attached also.

Ex:-

CleanTab:

Mapping LOAD * Inline

[

MapLetter,CleanLetter

EMEA,E-M-E-A

];

Data:

LOAD *,RowNo() as Rowids ,ApplyMap('CleanTab',StrLetter) as New;

LOAD * Inline

[

StrLetter

ABCD

EMEA

ABCD

EMEA

EMEA

FGFD

EEEE

TTRRT

RTRT

EMEA

];