Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

IIF in sql editor

NicolasFabre81
8 - Asteroid

Hello,

In the SQL Editor of the input data tool (oracle database), I manage to make the Switch function run, but not the IIF, is it normal ?

IIF does work in Oracle : https://docs.oracle.com/cd/E57185_01/ESBTR/mdx_iif.html

3 REPLIES 3
JoeS
Alteryx
Alteryx

Are you able to share your example that you used.

 

It should be possible when used as part of your select statement

NicolasFabre81
8 - Asteroid

In fact the problem is that IIF does not exist in Oracle SQL. I should use DECODE instead.

Thableaus
17 - Castor
17 - Castor

Hi @NicolasFabre81 

 

You can use the DECODE function to perform the same thing.

 

Cheers,

Labels