Translate Listbox Display Value

[Johnnyg248]

Have a flag field in sql table that is a bit field  (value is 0 or 1)

Is it possible to "translate" the field so list box would display 'Y' or 'N'?

I guess could just translate in load script but just curious

[jaibau1993]

Hi! You can translate it in the script:

LOAD
...
if(BitField = 1, 'Y', 'N') as TranslatedBitField
...

Also, you can create a calculated dimension in a chart or listbox as well (no script modifications).

Hope it helps!
Jaime.

[marcus_sommer]

It could be also done within the listbox by choosing an expression as source and not a field. I assume that you have multiple of such flag-fields and then a script-solution would be probably more suitable - maybe also as dual() values, like: dual('Y', 1).

- Marcus