Null handling error

[srinivas.nettalam]

Hello Everyone,
I have an if..then..else expression used ina stage variable.
The derivation is like if NullToZero(col1)=NullToZero(col2) then 'A' else 'B'

The job aborted due to the error "Null handling function called on not nullable field" that message is in high level and I am unable to debug.

Usually null handling is done for not nullable fields right?Please let me know the reason for the error

[viswanath123]

U might hve confused with that.. Normally Null handling is done for Nullable fields.

[srinivas.nettalam]

U might hve confused with that.. Normally Null handling is done for Nullable fields.

I meant not nullable field in the end not from the input..sorry

[soumya5891]

Check the nullability defined in the Output column.It should be null.

[srinivas.nettalam]

Check the nullability defined in the Output column.It should be null.

just to handle that i am handling null in the derivation so tht it always has values

[chulett]

Seems to be saying that (at least) one of your input columns is not nullable.