CODEWITHSUNDEEP
spotfiretibcotibco-topic
Chitra
Chitra

Reputation: 21

How to only display rows without a specific word in spotfire

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

Upvotes: 1

Views: 1328

Answers (1)

ksp585
ksp585

Reputation: 1770

@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!

Upvotes: 4

Related Questions