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.