This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i have loaded data in qlikview column name is domain
now requirement is to update the name of SS to 'shared services' and FS as 'Fundamental Services'
May be this
Pick(Match(domain, 'SS', 'FS', 'CBS'), 'shared services', 'Fundamental Services', '...') as domain
View solution in original post
Its so Simple.
CBS As [New Field];
simply rename the columns
SS as [Shared Services]
FS as [Fundamental Services]
If(Wildmatch(Domain,'SS.','FS'), 'shared services', 'Fundamental Services') as Newdomain
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.