Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
jerownimow
Contributor III
Contributor III

How to skip record with null pointer exception error and catch it and then proceeds with the next record?

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!

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

@jerome29 ,not understand why are you using globalmap key? and it was setting the globalmap key?

 

can you share your job design?