topic Re: Renaming field value in script in QlikView

Renaming field value in script

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

Hi,

How to rename field value in script level.

Field: HPTOX

Value with in field : Electric

Here i need to rename Electric into Electric\GE

Thanks..

Aurelien_Martinez — Thu, 01 Dec 2016 13:45:37 GMT

Hi,

Load

Pick(Match(HPTOX, 'Electric')+1, HPTOX, 'Electric\GE') as HPTOX

[..]

you can use mapping load / applymap function

Aurélien

nareshthavidishetty — Thu, 01 Dec 2016 13:56:34 GMT

Hi,

I have the got the answer with the below logic as well.

if(left(HPTOX,8)='Electric','Electic\GE',HPTOX) as HPTOX

Thanks..