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,
