Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
I have this flow of job:
tFileinputDelimited ->tMap [left outer join with tFileinputDelimited ->tFilterRow (lookup to Tmap)] -> output.
tFileinputDelimited(main) has the columns emp,emp_id,mngr_id,nxtmngr_id,nxtmngr_nam,H. manager is being being stored in a globalmap key in tMap and that globalmap variable will be called in tFilterRow(fields: emp,emp_id,manager), so the tFilterRow has emp_id = globalmap key.
Here's the issue, when this record for example:
tFileinputDelimited(main):
emp,emp_id,mngr_id,nxtmngr_id,nxtmngr_nam,H
Berna Aqui, berna.aqui, dam.sari, <blank>,<blank>,<blank>
when dam.sari does not exist on the lookup it throws nullpointer exception error and it stops the process.
What I want is to skip and catch Berna's record and continue on the next record. This record will be kept and be emailed to the respondents or whatsoever. But the main goal is to capture that record which has nullpointer exception and proceed with the next one.
Let me know if you need more info and thank you in advance for your inputs, experts!
@jerome29 ,not understand why are you using globalmap key? and it was setting the globalmap key?
can you share your job design?