11 Replies Latest reply: Mar 6, 2017 1:18 AM by sumit jadhav RSS

    Check for a word and identify similar word

    Raghav B

      Hi Friends,

       

      Kindly help me out with below case.

      My data is as below.

       

         

      Org. NameMatchCase
      Award1
      Star2
      Certificate3
      Appreciation4
      Match5

       

      My output should be

       

         

      Org. NameMatchCase
      Award1
      Awards1
      Star2
      Stars2
      Certificate3
      Certificatee3
      Appreciation4
      Appreciation s4
      Match5
      Match es5

       

      Here my intension is, qlikview script should treat the similar words(ex: Award/Awards) as same MatchCase. Is there a way to achieve this. Plz help.


      Thanks,

      Raghav