Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

IIF in sql editor

Highlighted

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

Highlighted
Alteryx
Alteryx

Are you able to share your example that you used.

 

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

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @NicolasFabre81 

 

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

 

Cheers,

Labels