Derived Column Transformation Editor Question

Help...

I'm having trouble coming up with a valid expression in my derived column transformation editor that tests the input column for NULL and responds something like this:

if[message] isNull then "NA" else [message]

where [message] is the input column.

Thanks!

Try:

ISNULL([message]) ? "NA" : [message]

|||SWEET!! Thanks!

Derived Column Transformation Editor Question

Help...

I'm having trouble coming up with a valid expression in my derived column transformation editor that tests the input column for NULL and responds something like this:

if[message] isNull then "NA" else [message]

where [message] is the input column.

Thanks!

Try:

ISNULL([message]) ? "NA" : [message]