Solved: Renaming field value in script - Qlik Community - 1261495

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

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..

1 Solution

Accepted Solutions

Hi,

Load

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

[..]

OR

you can use mapping load / applymap function

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

2 Replies

Hi,

Load

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

[..]

OR

you can use mapping load / applymap function

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!

Author

Hi,

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

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

Thanks..