Using sql with ternary op doesn't work in Tableau

[dmserg]

Using sql with ternary op doesn't work in Tableau - Questionmark(?) is treated as unnamed binding parameter. Example: Select (1 = 2 ? 3 : 4) is translated into select (1 = 2 {odbc_positional_1:Nullable(Nothing)} 3 : 4)

Replacing it with 'if' is a valid workaround but we have quite a lot big SQL reports using ternary op already. What's your view on this? Can it be fixed by distinguishing ternary from binding parameter?

[traceon]

You can try \ to escape ?'s.

[dmserg]

You can try \ to escape ?'s. This doesn't work, 'unrecognized token' error.

[huangxp12]

+1 ，I found the same problem using Power BI . Replacing all sql with 'if' is time cost as we have hundreds of querys Is there any easier way to solve it?