Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Andy,
you can use Replace function like below
Replace(Replace(Replace(MYFIELD,'ABC',99),'CBA',99),'ZZZ',000) as MYFIELD;
Regards,
Sultan
Hi Andy,
you can use Replace function like below
Replace(Replace(Replace(MYFIELD,'ABC',99),'CBA',99),'ZZZ',000) as MYFIELD;
Regards,
Sultan