Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

rido1421
Not applicable

Wild Card Search within applymap

Hi There

I have two tables

Customer:

Load

Name1 ,

Contact

SurName

from CustomerFile;

MapTable:

Mapping Load

Name1 as Name,

SurName

Resident Customer;


Sales:

Load

Name,

SalesValue,

ApplyMap('MapTable',Name,Null()) as Surname

from SalesFile;

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.

Regards,

3 Replies
avinashelite
Not applicable

Re: Wild Card Search within applymap

rido1421
Not applicable

Re: Wild Card Search within applymap

Thanks Avinash... but I dont quite get the solution...