Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

In-Database Formula usage

Gelly
6 - Meteoroid

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. 

 

 

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

_

apathetichell
18 - Pollux

[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
6 - Meteoroid

I see. That makes sense. Thanks!

atcodedog05
22 - Nova
22 - Nova

Guess i have lot more to learn 😅😀

Gelly
6 - Meteoroid

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
18 - Pollux

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

NatalieH
Alteryx
Alteryx

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

Labels