topic Re: field value in QlikView

field value

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

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 — Mon, 11 Sep 2017 15:07:24 GMT

May be this?

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

its_anandrjs — Mon, 11 Sep 2017 17:10:45 GMT

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

FGFD

EEEE

TTRRT

RTRT

EMEA

];