Alteryx designer Discussions

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

IIF in sql editor

Highlighted
7 - Meteor

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

Highlighted
7 - Meteor

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