topic Re: Wild Card Search within applymap in QlikView

Wild Card Search within applymap

rido1421 — Thu, 23 Jun 2016 09:50:17 GMT

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,

avinashelite — Thu, 23 Jun 2016 10:02:20 GMT

check this thread

rido1421 — Thu, 23 Jun 2016 10:42:44 GMT

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

MarcoWedel — Fri, 24 Jun 2016 23:45:08 GMT

Hi,

maybe this helps:

regards

Marco