topic Re: Change in QlikView

Change

smilingjohn — Fri, 26 Feb 2016 09:52:22 GMT

Hi Community ,

In my file i have field called Name in which the data is like >=HIde SN or Rs

Now where ever there is SN it should it shoud be replaced by Sense and RS should be Ross

the out put should be like this

Input Output

<=2-SN-HIDE Sense

8-SN Sense

>=64-RS Ross

=det-23< =det-23<

wet<tt/40 wet<tt/40

Tahnks in advance

Re: Change

Anonymous — Fri, 26 Feb 2016 10:00:23 GMT

try like this at script?

If(Fieldname like '*SN*', Replace(FieldName, 'SN','Sense'),

If(Fieldname like '*RS*', Replace(FieldName, 'RS','Ross')) as NewField

Re: Change

Anonymous — Fri, 26 Feb 2016 10:01:32 GMT

Hi John,

Please try the following in the script:

if(Name = {'*SN*'}, 'Sense',

if(Name = {*RS*}, 'Ross')

) as Name

Re: Change

Anonymous — Fri, 26 Feb 2016 10:03:47 GMT

check the attachment?

Re: Change

tresB — Fri, 26 Feb 2016 10:04:54 GMT

Try like:

Clause:

LOAD

If(Index(Name, 'SN'), 'Sense', If(Index(Name, 'RS'), 'Ross', Name)) as Name,

Location

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Change

sunny_talwar — Fri, 26 Feb 2016 10:04:59 GMT

May be the requirement is this:

If(WildMatch(Name, '*SN*', 'Sense', If(WildMatch(Name, '*RS*', 'Ross', Name)) as NewName

Re: Change

Anonymous — Fri, 26 Feb 2016 10:05:42 GMT

This will not work as this is not the proper format for comparing wildchar(*)....

Like, Wildmatch(),match() etc are used for those such comparison

Re: Change

tamilarasu — Fri, 26 Feb 2016 10:34:51 GMT

You can also use,

Pick(WildMatch(Upper(Trim(Name)),'*SN*','*RS*')+1,Name,'Sense','Ross') as NewName