Changing more than one value on input

[AndyHill]

Hi There

I am quite new to Qlikview, and I have spent a couple of hours on here trying to work out how to change a couple of values inbound from a SharePoint input.  Ideally I would fix the input however it is owned by a different department, so the best solution is to do it on the load part.

Process is:

LOAD

...

,Replace(MYFIELD,'ABC','99') as MYFIELD

...

However I need to make a few more changes ... initially I tried this:

,Replace(MYFIELD,'ABC','99') as MYFIELD

,Replace(MYFIELD,'CBA','99') as MYFIELD

,Replace(MYFIELD,'ZZZ','00') as MYFIELD

However this doesn't work.  How is it possible to put multiple "REPLACE" lines together?

Andy

[sultanam · Accepted solution]

Hi Andy,

you can use Replace function like below

Replace(Replace(Replace(MYFIELD,'ABC',99),'CBA',99),'ZZZ',000) as MYFIELD;

Regards,
Sultan