Hi
I am having a problem with null handling. My code in tranformer derivation is-
If In_Tfm_EmpId_Customer.TRAN_TYPE='EMPSALE' AND In_Tfm_EmpId_Customer.CUSTOMER<>' ' Then NullToValue(In_Tfm_EmpId_Customer.ASSOC_ID,' ') Else NullToValue(In_Tfm_EmpId_Customer.EMP_ID,' ')
But still I am getting null values.
Please help
Regards
Arnie
problem in null handling
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Null values are a bit tricky here.
Seems, for these 2 fields you are getting Null values from the source.
And you are not making Null checks for In_Tfm_EmpId_Customer.TRAN_TYPE, In_Tfm_EmpId_Customer.CUSTOMER.
The code would be this way:
Seems, for these 2 fields you are getting Null values from the source.
And you are not making Null checks for In_Tfm_EmpId_Customer.TRAN_TYPE, In_Tfm_EmpId_Customer.CUSTOMER.
The code would be this way:
Code: Select all
If NullToEmpty(In_Tfm_EmpId_Customer.TRAN_TYPE) ='EMPSALE' AND NullToEmpty(In_Tfm_EmpId_Customer.CUSTOMER) <> ''
Then NullToValue(In_Tfm_EmpId_Customer.ASSOC_ID,' ')
Else NullToValue(In_Tfm_EmpId_Customer.EMP_ID,' ')
Thanks and Regards!!
dspxlearn
dspxlearn