How to only display rows without a specific word in spotfire

1.1k views Asked by At

Below is the dataset. I want to display only the rows that doesn't have "confidential" in the description column in spotfire. Thanks.

enter image description here

1

There are 1 answers

0
ksp585 On

@Chitra- In data table properties > Limit data using expression, insert the below expression to filter out rows which contains 'confidential' in column Test.

not(Lower([Test])~='confidential')

Here is the final output:

enter image description here

Hope this helps!