Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Possible to rename one data value?

I am quite familiar with changing field names using the "as" modifier in the load script, but is it possible to rename a data point in a field within a load script (or even better - an object)?  If so, how?

I.E if my field is "Fruits" and I want to rename "oRanjes" to "Oranges", is that possible without editing the underlying data?

14 Replies
munna1317
Creator II
Creator II

PLZ find the attachments ,

through Mapping load and by using Applymap we can do it.

munna1317
Creator II
Creator II

hi marco ,,

Through Mapping load and Apply Map we can change spelling for that by using another table its very simple scenario ,

Thxs and regards ,

HArish

Colin-Albert

Yes you can use replace in the load script or on the from end.

Obviously it is better to do it once in the script, but you can test it on the from end.

Also you can cascade several replace commands together.

     replace(replace(replace(field,'aa','cc'),'mm','nn'),'xx','yy')

Not applicable
Author

This worked great - thank you for your patience, Colin!

Not applicable
Author

Hi Harish -

Thank you for the help!  I see how this works now   Many thanks!