topic Re: Re: Possible to rename one data value? in QlikView

Possible to rename one data value?

Thu, 25 Sep 2014 15:09:47 GMT

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?

Re: Possible to rename one data value?

munna1317 — Thu, 25 Sep 2014 15:12:18 GMT

use string fuctions it may help you

Re: Possible to rename one data value?

munna1317 — Thu, 25 Sep 2014 15:16:39 GMT

capitalize( 'oRanjes')

Re: Possible to rename one data value?

Thu, 25 Sep 2014 15:18:56 GMT

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.

Re: Possible to rename one data value?

Colin-Albert — Thu, 25 Sep 2014 15:21:50 GMT

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

Re: Possible to rename one data value?

maxgro — Thu, 25 Sep 2014 15:23:28 GMT

load

....

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

also with applymap

Re: Possible to rename one data value?

munna1317 — Thu, 25 Sep 2014 15:23:52 GMT

hi , plz provide same QVW it is easy solve

thxs ,

Harish

Re: Re: Possible to rename one data value?

Thu, 25 Sep 2014 15:32:05 GMT

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

Re: Re: Possible to rename one data value?

Colin-Albert — Thu, 25 Sep 2014 15:36:29 GMT

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

Re: Re: Possible to rename one data value?

Thu, 25 Sep 2014 15:39:23 GMT

So do I include that in the load statement?

Re: Possible to rename one data value?

munna1317 — Thu, 25 Sep 2014 15:45:19 GMT

PLZ find the attachments ,

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

Re: Possible to rename one data value?

munna1317 — Thu, 25 Sep 2014 15:52:45 GMT

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

Re: Re: Possible to rename one data value?

Colin-Albert — Thu, 25 Sep 2014 15:58:22 GMT

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

Re: Re: Possible to rename one data value?

Thu, 25 Sep 2014 17:07:43 GMT

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

Re: Re: Possible to rename one data value?

Thu, 25 Sep 2014 17:08:30 GMT

Hi Harish -

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