Alisha Stacy Posted March 23, 2020 Share Posted March 23, 2020 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 More sharing options...
Shashank Gurnalkar Posted March 24, 2020 Share Posted March 24, 2020 Can you try to use this expression for the new column: case when [fruit] = "red delicious apple" then "apple" when [fruit] = "gala apple" then "apple" end Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now