Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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