5 Replies Latest reply: Feb 19, 2016 7:50 AM by xavier hemelaar RSS

    replace partialy field values

    xavier hemelaar

      Hi Qlikers,

      I would like to know if there is a way to replace partialy some field values. Let say I have a column A that I load, but during load if the value is like '*test*' then "test" hase to be replaced by "OK".

      LOAD

      if (A like '*test*', ...'OK'... ) AS A

      From...

       

      So if value is " this is a test" I would like to have the following result: "this is a OK"

      Thanks for your help