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

[jayshrinipurte]

Dear Capricon,

WildMatch() function will help you.

If(WildMatch(Field_Name,'Knee*'),'Kneee',

If(WildMatch(Field_Name,'Eye*'),'Eye'))

Regards,

Jayshri

[keerthika]

Hi,

Try this one

if(WildMatch(name,'knee*'),'Knee',

if(WildMatch(name,'eye*'),'eye',

'other'))

[capriconuser]

what if

like i have a knee word where this is place in the end ,in between or anywhere position ..

like anywhere knee word is identified i want to name as "knee"

like this

knee join

joint knee break

break knee join 2

Abrasion, left knee, initial encounter

i want to name this all as "knee"

[jayshrinipurte]

If(WildMatch(Field_Name,'*Knee*'),'Kneee',

If(WildMatch(Field_Name,'*Eye*'),'Eye'),

'Others')

[petter · Accepted solution]

As the other suggested you can use the WildMatch() function although it is not necessary to complicate it with multiple Wildmatch and If:

     Pick(WildMatch(Lower(Bodypart),'knee*','eye*','mouth')+1,'other','knee','eye','mouth')

[capriconuser]

this expression did not work this shows an error on others

[petter]

You will have to use the wildcard pattern:

     '*knee*'     which will pick any sentence with the characters knee in it

[jayshrinipurte]

If(WildMatch(Field_Name,'*Knee*'),'Kneee',

If(WildMatch(Field_Name,'*Eye*'),'Eye',

'Others'))

[capriconuser]

this is not working i have several words where knee word word is exist but none of them is displayed