3 Replies Latest reply: Jun 24, 2016 7:45 PM by Marco Wedel RSS

    Wild Card Search within applymap

    Ridhaa Hendricks

      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,