Spotfire Client: How to filter out data rows containing specific words

In some cases, it might be required to filter out data rows from a data table based on the presence of certain words. 

If the data column in question has a limited and unique list of values, the rows can be easily filtered with the help of built-in Spotfire filters. 

However, there can be scenarios where such words appear in a natural language data column (e.g. under ‘comments’ or ‘description’ columns) and might not be filtered directly. 

To create a limited view of the data that does not contain the phrase 'test' see the below steps:

1.    Right click on the visualization.
2.    Click on ‘Properties’
3.    In the ‘Properties’ dialog box, click on ‘Data’ >> ‘Limit Data using expression’ >> ‘Edit…’.
4.    Use the following expression "not(Lower([Comments]) ~= 'test')"

Here, [Comments] is the name of the data column and ‘test’ is the specific word we are looking for. 

The expression will limit the rows based on the occurrence of word ‘test’. 

The operator ‘~=’; makes the expression limit all the data rows that contains the word ‘test’ in data column [Comments]