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
In fact the problem is that IIF does not exist in Oracle SQL. I should use DECODE instead.
Are you able to share your example that you used.
It should be possible when used as part of your select statement
Hi @NicolasFabre81
You can use the DECODE function to perform the same thing.
Cheers,
