Jump to content
We've recently updated our Privacy Statement, available here. ×

Spotfire Contains

Alisha Stacy

Recommended Posts

I'm attempting to create a calculated column that returns a value if an existing column has a specific word in it. I have seen other posts use "~=" but that doesn't seem to work for me. It returns an error that says "could not find function '~="Looking to create something along these lines...

when [fruit]~="red delicious apple" then "apple"

when [fruit]~="gala apple" then "apple"

My relevant column data type is a text string.

Any help would be appreciated.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...