topic Re: renaming a value in the field while loading the data in QlikView

renaming a value in the field while loading the data

Anonymous — Fri, 03 Jul 2015 16:36:55 GMT

Hi,

I have a field 'Brands' in my source data. I've loaded the field in my model:

Load

[Brands]

...

I'd like to rename one particular value in this field while loading the data. I'd like to rename 'Total' into 'All Market'. How can I do it in the script?

Thank you in advance,

Larisa

Re: renaming a value in the field while loading the data

maxgro — Fri, 03 Jul 2015 16:40:07 GMT

load

.....,

if(Brands='Total', 'All Market', Brands) as Brands,

.....

Re: renaming a value in the field while loading the data

swuehl — Fri, 03 Jul 2015 16:40:10 GMT

LOAD

if([Brands]='Total','All Market', [Brands]) AS [Brands],

...

For a more sustainable solution, you can also look into a MAPPING solution.

Re: renaming a value in the field while loading the data

Anonymous — Fri, 03 Jul 2015 17:41:24 GMT

Thank you!