Hi,
I am using the below logic in transformer as filter condition and getting the error message as "Fatal Error: Null value on the accessor interfacing to field "TrxnTyp".
(IsNotNull(DSLink110.TrxnTyp) and IsNotNull(DSLink110.TrxnTypDtl) and
(TRIM(DSLink110.TrxnTyp)=5 and TRIM(DSLink110.TrxnTypDtl)=4)) Or
(IsNotNull(DSLink110.TrxnTyp_2) and IsNotNull(DSLink110.TrxnTypDtl_2) and
(TRIM(DSLink110.TrxnTyp_2)=5 and TRIM(DSLink110.TrxnTypDtl_2)=4)) Or
(IsNotNull(DSLink110.TrxnTyp_3) and IsNotNull(DSLink110.TrxnTypDtl_3) and
(TRIM(DSLink110.TrxnTyp_3)=5 and TRIM(DSLink110.TrxnTypDtl_3)=4)) Or
(IsNotNull(DSLink110.TrxnTyp_4) and IsNotNull(DSLink110.TrxnTypDtl_4) and
(TRIM(DSLink110.TrxnTyp_4)=5 and TRIM(DSLink110.TrxnTypDtl_4)=4)) Or
(IsNotNull(DSLink110.TrxnTyp_5) and IsNotNull(DSLink110.TrxnTypDtl_5) and
(TRIM(DSLink110.TrxnTyp_5)=5 and TRIM(DSLink110.TrxnTypDtl_5)=4)) Or
(IsNotNull(DSLink110.TrxnTyp_6) and IsNotNull(DSLink110.TrxnTypDtl_6) and
(TRIM(DSLink110.TrxnTyp_6)=5 and TRIM(DSLink110.TrxnTypDtl_6)=4)) Or
(IsNotNull(DSLink110.TrxnTyp_7) and IsNotNull(DSLink110.TrxnTypDtl_7) and
(TRIM(DSLink110.TrxnTyp_7)=5 and TRIM(DSLink110.TrxnTypDtl_7)=4)) Or
(IsNotNull(DSLink110.TrxnTyp_8) and IsNotNull(DSLink110.TrxnTypDtl_8) and
(TRIM(DSLink110.TrxnTyp_8)=5 and TRIM(DSLink110.TrxnTypDtl_8)=4)) Or
(IsNotNull(DSLink110.TrxnTyp_9) and IsNotNull(DSLink110.TrxnTypDtl_9) and
(TRIM(DSLink110.TrxnTyp_9)=5 and TRIM(DSLink110.TrxnTypDtl_9)=4))
Could you please let me know the issue.
Null value on the accessor interfacing to field
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 32
- Joined: Tue Mar 09, 2010 5:56 am
- Location: Bangalore
Null value on the accessor interfacing to field
Thanks & Regards,
Partha
Partha
Re: Null value on the accessor interfacing to field
you have NULL value in TrxnTyp field...
-
- Premium Member
- Posts: 32
- Joined: Tue Mar 09, 2010 5:56 am
- Location: Bangalore
Re: Null value on the accessor interfacing to field
Ya I know there are some null values are there, that is why I am using IsNotNull(TrxnTyp) in the condition.
Thanks & Regards,
Partha
Partha
-
- Premium Member
- Posts: 32
- Joined: Tue Mar 09, 2010 5:56 am
- Location: Bangalore
Even I have tried with this logic as well but the same error I am getting again.
(TRIM(NulltoValue(DSLink110.TrxnTyp,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_2,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_2,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_3,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_3,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_4,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_4,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_5,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_5,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_6,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_6,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_7,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_7,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_8,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_8,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_9,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_9,''))=4)
(TRIM(NulltoValue(DSLink110.TrxnTyp,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_2,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_2,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_3,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_3,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_4,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_4,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_5,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_5,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_6,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_6,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_7,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_7,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_8,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_8,''))=4) Or
(TRIM(NulltoValue(DSLink110.TrxnTyp_9,''))=5 and TRIM(NulltoValue(DSLink110.TrxnTypDtl_9,''))=4)
Thanks & Regards,
Partha
Partha
-
- Premium Member
- Posts: 32
- Joined: Tue Mar 09, 2010 5:56 am
- Location: Bangalore