Intially i had one expression for a stage variable
Code: Select all
if TrimIndicator ='A' and ValidZip='ZIPVALID' and ValidMail='MAILVALID' and ValidSmail='SMAILVALID'
then
'VALID'
else
'REJECT'
I got one fatal error 'Null value on the accessor interfacing to field "INDICATOR".'
Note :where TrimIndicator is a stage variable with expression 'Trim(NullToEmpty(transformer_link.INDICATOR))'
and it has null values too.
so i modified the expression as follows
Code: Select all
if TrimIndicator='' then
'REJECT'
else
(if ValidZip='ZIPVALID' and ValidMail='MAILVALID' and ValidSmail='SMAILVALID'
then
'VALID'
else
'REJECT')
so i want to know what went wrong in the first case. Your help would be highly appreciated
Regards,
Raja R P