IIF in sql editor

[NicolasFabre81]

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

[JoeS]

Are you able to share your example that you used.

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

[NicolasFabre81 · Accepted solution]

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

[Thableaus]

Hi @NicolasFabre81 

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

Cheers,