Wildcard Mapping in QlikSense

[toddprete]

Does anyone have an example of how I can do Wildcard mapping in Qliksense scripting.

Basically I have a list of names in a mapping table.   I want to search all my customer names from the customer table to see if the name contains any of words in the mapping table.

Mapping Table:

Osama

Guns

Weapons

Church

OJ Simpson

I want to know if the Customer Name contains any of the words in the mapping table.  So if the Customer Name is 'We sell Guns' then that is a hit.

Thanks  Todd

[marcus_sommer]

You could do it with mapsubstring() similar to this one: Re: Passing parameter strings that contain special characters.

- Marcus