Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Vedant_Patel
Contributor
Contributor

How to do Rename of Field value ???

Dear Sir / Madam,

I have Field name "Country Language" in which Values are Country wise Local Language...

I want to Convert it into English Language ...

eg. is in attached Excel Sheet.

 

How can it possible... ??? 

There are many Fields like this in which convert from Local Language in to English Language ... 

 

Labels (1)
1 Reply
Dalton_Ruer
Support
Support

If I'm understanding correctly you want to change the name of the FIELDS not the values in the fields. 

I think RENAME FIELD is what you need to use in your Load Script. It would allow you to read in the Old Field Name and the New Field Names and then apply that. Example 2 in the following link will show you that and don't mind the fact that the example loads from a SQL table, you can use your XLSX file to create the FieldMap table. 

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptR...