like in qlikview

[capriconuser]

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 join	knee
kneepain	knee
Abrasion, left knee, initial encounter	knee
knee JT	knee
eye	eye
eye pain	eye
eye damage	eye
eyelid retraction right eye	eye
mouth	mouth
abdomen	other
dysprea	other
frontal	other

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..

[capriconuser]

not working just this file

[capriconuser]

what is +1 here?

[jayshrinipurte]

Dear Capricorn,

Find the below attachment

Regards,

Jayshri

[petter]

The addition of one will make sure that if there is no match the 'other' is picked...

WildMatch(Lower(Bodypart),'knee*','eye*','mouth') will return 0 (if not match), 1 for 'knee*' 2 for 'eye*' 3 for 'mouth'

by adding 1 you can cater for no match too in the Pick function....