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!
No comments:
Post a Comment