Like other table

Anonymous — Tue, 19 Apr 2016 12:13:40 GMT

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?

topic Re: Like other table in QlikView

Like other table

Re: Like other table