Like other table

[Anonymous]

Hi guys. I have two tables:

Live:

Load

     [Customer #]    as CustomerNumber,
     [address line 1]    as Address1,
     [address line 2]    as Address2,
     [address line 3]    as Address3,
     [address line 4]    as Address4,
     [address line 5]    as Address5

From (ooxml, embedded labels, Table is 'Report');

Towns:

Load
[Invalid town]

From
(ooxml,embedded labels, Table is 'Towns');

I need something similar to "Like" where i can search each address field to see if it contains any of the words in [Invalid town]. For example:

[Invalid Town] might contain the word "Peterborough" but the Address1 field might read '1 close rd, Peterborough' and i want that to be picked up

I would use EXISTS and NOT EXISTS but i'm not looking for an exact match. Can anyone help?

[sunny_talwar · Accepted solution]

Check out MapSubString()

Mapping … and not the geographical kind

MapSubstring in left X characters | Qlik Community‌

Using MapSubstring() to edit strings | Qlikview Cookbook