Solved: Possible to rename one data value? - Qlik Community

Report Inappropriate Content · ‎2014-09-25

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?

Colin-Albert · ‎2014-09-25

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')

View solution in original post

munna1317 · ‎2014-09-25

use string fuctions it may help you

munna1317 · ‎2014-09-25

capitalize( 'oRanjes')

Report Inappropriate Content · ‎2014-09-25

Ah, my example was meant to be just that. I'm actually looking to entirely rename a single data value within a field, not capitalize it.

Colin-Albert · ‎2014-09-25

=REPLACE(Fruits, 'oRanjes', 'Oranges')

maxgro · ‎2014-09-25

load

....

if(Fruits = "oRanjes", "Oranges", Fruits) as Fruits

also with applymap

munna1317 · ‎2014-09-25

hi , plz provide same QVW it is easy solve

thxs ,

Harish

Report Inappropriate Content · ‎2014-09-25

Here you are! So let's say I want to change the value "Eggplant" to "Aubergine" - how would I do that?

Colin-Albert · ‎2014-09-25

The replace function will replace all occurrences of txt1 with txt2 in fieldA

replace(fieldA, 'txt1', 'txt2') as fieldA

replace(Fruits, 'Eggplant', 'Aubergine') as Fruits

Report Inappropriate Content · ‎2014-09-25

So do I include that in the load statement?