Discussion Board for collaboration related to QlikView App Development.
I have a table (Bad_Words) which contains a list of 100 odd Bad Words; such as
Now, I know how to identify if the full field matches one of these words.
What I am trying to work out is an easy way to identify if a field contains any of the words in this table
Ie. 'MAIL RETURNED' in a field would be caught as 'RETURNED' is in the Bad_Words table