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.
Solved! Go to 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
I see. That makes sense. Thanks!
Guess i have lot more to learn 😅😀
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
@Gelly- they need to change that. Totally confusing.
@apathetichell @Gelly Thanks for the feedback! I've updated the article.