How to process the next iteration when the first extract on tfilterrow returns null pointer exception?

[jerownimow]

Hi Experts, Good day!

I have a job:

Inside the tMap:

The globalMap key will be used as a condition on tFilterRow to get the corresponding nxtMngrdn. However, when the record does not exist on the lookup it throws a NullPointerException error due to the fact that there's no row returned from tFilterRow.
What I want to have is to ignore the Null Pointer and continue with the process and for that specific record the output will be the values from the left table and only blank/null values from the lookup table if the record does not exist.

For ex:
displayName;dn;manager
David Shays;cn=dshays;cn=vladimirs
When cn=vladimirs does not exist on the filtered lookup, it will only return blank/null and it will not throw a Null Pointer error.

tFilterRow is essential and should not be removed as it is used to get the next manager level.

Please let me know your thoughts on this.

Thank you.

[Anonymous]

Sorry I missed your question on Sunday. I'm afraid this is the first time I have been on since you raised it. However you solved it in exactly the way I would have suggested 🙂