Define field types by certain content contained

[Vince_CH]

Dear Friends,

I have one field containing unregular contents like below. I want to define the field type differently if it contains certain contents inside, e.g. if including "bearing", then to define the type as Bearing. 

In excel search, it is possible to search ambiguously, i am not sure if in Qlik sense there is such function similarly? 

thanks in advance!

[vishsaggi · Accepted solution]

DId you try like below change the else condition value as your require.

=IF(Wildmatch(Description, '*bearing*')>0, 'Bearing', Description)

[Vince_CH]

thanks, it works great!