Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
toddprete
Contributor II
Contributor II

Wildcard Mapping in QlikSense

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

1 Reply
marcus_sommer

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

- Marcus