13 Replies Latest reply: Apr 17, 2018 6:23 AM by Petter Skjolden RSS

    like in qlikview

    Capricon User

      I have a data like this

       

      knee join

      knee pain

      knee

      knee JT

      eye

      eye pain

      eye damage

      eyelid retraction right eye

      mouth

      abdomen

      dysprea

      frontal

       

      now i want to get like this ...

       

      like when anywhere where knee  word is found i want to name all these word with knee and when any word start from eye then want to name it eye

      and except this all renaming i want to name it "other"

       

      knee joinknee
      kneepain                                 knee
      Abrasion, left knee, initial encounterknee
      knee JTknee
      eyeeye
      eye paineye
      eye damageeye
      eyelid retraction right eyeeye
      mouthmouth
      abdomenother
      dyspreaother
      frontalother

       

       

      i tried this

      If(WildMatch(col1,'*knee*'),'Kneee',If(WildMatch(col1,'*eye*'),'Eye'))

       

      but this shows only 1 result with eye where as i have 3 records related to eye and knee record is not display..