topic Re: Renaming Field Content in QlikView

Renaming Field Content

Tue, 12 Feb 2013 14:52:08 GMT

Hi,

i have loaded an excel file with multiple fields.

One field is company code with data such as 1, 2, 3, 4, 5

i want to change the values so for example 1=company a, 2= company b , 2-3-4=Other

what code do i need to use for this

thanks

laura

Re: Renaming Field Content

SunilChauhan — Tue, 12 Feb 2013 14:54:37 GMT

If(Code=1,'a',

If(Code=2,'b',

'Others')) as CompanyName

hope this helps

Re: Renaming Field Content

Tue, 12 Feb 2013 14:55:07 GMT

Try ApplyMap

Kind Regards

Footsie

Re: Renaming Field Content

hic — Tue, 12 Feb 2013 18:21:38 GMT

Applymap is a much, much, much better solution. An if-function works, but is not manageble. You will soon have more than two values that you want to map to strings.

If you do a

MappingTable:

Mapping Load * inline

[From, To

1, company a,

2, company b ,

3,Other

4,Other];

then you can later, inside a Load statement do

Applymap('MappingTable',Code) as CompanyName

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap

HIC