how to rename the field value name

[abc_18]

i have loaded data in qlikview column name is domain

having values

domain

SS.

CBS

FS

now requirement is to update the name of SS to 'shared services' and FS as 'Fundamental Services'

[arvind_patil]

Hi ,

Its so Simple.

CBS As [New Field];

Thanks,

Arvind Patil

[sunny_talwar · Accepted solution]

May be this

LOAD

     Pick(Match(domain, 'SS', 'FS', 'CBS'), 'shared services', 'Fundamental Services', '...') as domain

[Chanty4u]

simply rename the columns

load  *,

domain

SS  as [Shared Services]

CBS 

FS  as [Fundamental Services]

];

[arvind_patil]

Hi Shikha,

If(Wildmatch(Domain,'SS.','FS'), 'shared services', 'Fundamental Services') as Newdomain

Thanks,

Arvind Patil

[balar025]

You can go with Applymap at scriptside.

In future if you want to change any other domain name then you can easily enter name at one table it will reflect in others.

[abc_18]

Thanks Sunny