topic Re: Replace more than one Value in QlikView

Replace more than one Value

Mon, 22 Oct 2012 13:29:47 GMT

I have the following column:

Medium:

cpc

none

organic

I would like to do the following replacements within Medium field: cpc --> PPC

none --> Direct

organic --> SEO

email --> Campaign

what function would be the best to use and how would the script look like?

Thanks,

Re: Replace more than one Value

MayilVahanan — Mon, 22 Oct 2012 13:33:01 GMT

Try like this

Whether use if condition

Mapping load * inline[

];

And then use ApplyMap, both helps

Re: Replace more than one Value

Mon, 22 Oct 2012 14:15:46 GMT

How would it look like with more than 2 if conditions?

Re: Replace more than one Value

Mon, 22 Oct 2012 14:20:34 GMT

ApplyMap is the better option.

Re: Replace more than one Value

alexpanjhc — Mon, 22 Oct 2012 18:52:45 GMT

i agree applymap looks nicer

but there you go

if (Medium='cpc', 'PPC', if (Medium='none', 'Direct', If (Medium='organice', 'SEO', if (Medium ='email', 'Campaign', null())))) as new_field;

Re: Replace more than one Value

alexpanjhc — Mon, 22 Oct 2012 18:53:36 GMT

i agree applymap looks nicer

but there you go

if (Medium='cpc', 'PPC', if (Medium='none', 'Direct', If (Medium='organice', 'SEO', if (Medium ='email', 'Campaign', null())))) as new_field;

Re: Replace more than one Value

rwunderlich — Mon, 22 Oct 2012 19:32:49 GMT

MediumMap:

MAPPING LOAD * INLINE [

cpc, PPC

none, Direct

organic, SEO

email, Campaign

]

;

MAP Medium UISNG MeduimMap;

-Rob

Re: Replace more than one Value

CELAMBARASAN — Mon, 22 Oct 2012 19:48:11 GMT

If the Replacement texts are less then you can go with this option also

Pick(Match(Medium,'cpc','none', 'organice','email'),'PPC','Direct','SEO','Campaign') AS NewField