Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

how to rename the field value name

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'

1 Solution

Accepted Solutions
sunny_talwar

May be this

LOAD

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

View solution in original post

6 Replies
arvind_patil
Partner
Partner

Hi ,

Its so Simple.

CBS As [New Field];

Thanks,

Arvind Patil

sunny_talwar

May be this

LOAD

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

Chanty4u
MVP
MVP

simply rename the columns

load  *,

domain

SS  as [Shared Services]

CBS 

FS  as [Fundamental Services]

];

arvind_patil
Partner
Partner

Hi Shikha,


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


Thanks,

Arvind Patil

balar025
Creator III
Creator III

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
Creator II
Creator II
Author

Thanks Sunny