In-Database Formula usage

[Gelly]

Hello, 

I am trying to create a new column using one column. 

For instance, I have a column named Operators with multiple rows containing iOS, Win, Linux in the rows.

I want to create a new Description column and say Apple, Microsoft, XYZ

I am using case to do this. 

CASE WHEN [Operators] = 'iOS' THEN 'Apple'

WHEN [Operators] = 'Win' THEN 'Microsoft'

WHEN [Operators] = 'Linux' THEN 'XYZ'

END

I am getting the following error. 

Error: ORA-00936: missing expression

Can you help me understand where am I going wrong?

P.S.: The exact SQL query logic works perfectly in outside database's formula tool but not in-database. 

[atcodedog05]

_

[apathetichell · Accepted solution]

[Operators] should be "Operators" - but you should use the insert field toggle to see how it's formatted exactly ("OPERATORS")?

CASE WHEN [Operators] = 'iOS' THEN 'Apple'

WHEN [Operators] = 'Win' THEN 'Microsoft'

WHEN [Operators] = 'Linux' THEN 'XYZ'

END

[Gelly]

I see. That makes sense. Thanks!

[atcodedog05]

Guess i have lot more to learn 😅😀

[Gelly]

Thanks! It worked! 

I got confused because of this and hence I didn't use "Operators" 

https://help.alteryx.com/20213/designer/formula-db-tool

[apathetichell]

@Gelly- they need to change that. Totally confusing.

[NatalieH]

  @apathetichell @Gelly Thanks for the feedback! I've updated the article.