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
Null handling error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
Null handling error
N.Srinivas
India.
India.
-
- Participant
- Posts: 3
- Joined: Thu Mar 17, 2011 12:29 am
Re: Null handling error
U might hve confused with that.. Normally Null handling is done for Nullable fields.
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
Re: Null handling error
I meant not nullable field in the end not from the input..sorryviswanath123 wrote:U might hve confused with that.. Normally Null handling is done for Nullable fields.
N.Srinivas
India.
India.
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Re: Null handling error
Check the nullability defined in the Output column.It should be null.
Soumya
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
Re: Null handling error
just to handle that i am handling null in the derivation so tht it always has valuessoumya5891 wrote:Check the nullability defined in the Output column.It should be null.
N.Srinivas
India.
India.