Discussion Board for collaboration on QlikView Scripting.
I have two tables
Name1 as Name,
ApplyMap('MapTable',Name,Null()) as Surname
Currently I am using apply map function to bring Surname into my sales table which works fine for exact matches.
I now need to do a "Wild Card" search within Name to return all surnames that contain the Name from Customers
eg. Name1 in the Customers table is 'John'
Name from the Sales table is 'Crazy John the 1 and only$'
This record must return Johns surname as John is within the Name in the sales table.
I appreciate your responses.
check this thread
Combine Wildmatch and Applymap for string compa... | Qlik Community
Thanks Avinash... but I dont quite get the solution...
maybe this helps:
Grouping List Box values
Match string to substring from another table
Keyword Mapping with Description
Multi-wildmatch on Text
How load necessary information from unstructured column?
Wildcard search need help urgent