Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Identify if field contains Bad Words

Hi,

I have a table (Bad_Words) which contains a list of 100 odd Bad Words; such as

NO MAIL
NONAME
NOT GIVEN
NOT PROVIDED
NOT SUPPLIED
RETURNED

etc

etc

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

Any thoughts?

Thanks

Stuart

0 Replies