79526371

Date: 2025-03-21 18:52:39
Score: 1
Natty:
Report link

Here's what worked for me with column values of Y, N, empty string. I had to use isNull for my derived column to be true, false, null.

toBoolean(toString(iif({ColumnName} == "Y", "1", iif(isNull({ColumnName}), "", "0"))))

Reasons:
  • Whitelisted phrase (-1): worked for me
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: ecsinsi