1 Reply Latest reply: Jun 30, 2017 2:55 PM by Marcus Sommer RSS

    Wildcard Mapping in QlikSense

    Todd Prete

      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