Unexpected NullPointerException in tMap

[Anonymous]

Hi Talend Community, i really need your help. 

I don't understand why i get a NullPointerException.

Here is my job :

First of all, i read all the datas from an excel file that is the input of the tMap below :

Let's focus on the EntreeProjet output because this is where the problem come from.

Untill now, there is no problem. The outputexcel_4 look like i want.

Here it comes...

I read the previous outputExcel on a lookup connection of the tMap below :

And i when i execute the job, i get the below error :

I desactivated all the other components.

I know what means a NullPointerException but i really don't understand why i get one here.

I have another output with the same schema but different datas and there is no problem. 

Thank you in advance. If you need more information, ask me.

[TRF]

Click the upper left button in the tMap component ("Setup the configurations of tMap") then untick the option "Die on error".

This will add an output flow called ErrorReject. Redirect this flow to a tLogRow component, it could help you to discover the origin of the exception.

[Anonymous]

I get this output. 

That's inetresting because, all the rows that i want to go in the tPivotToColumnsDelimited are going. But all the others get a nullPointerException.

[TRF · Accepted solution]

Based on your previous post it seems you take care of the "EntreeProjet" field but what about the "date" field?

If this field is null you'll get an NPE.

[Anonymous]

This field can't be null. There is always a date for every row.

As i told, all the rows i want are well send to the tPivotToColumnsDelimited like all my others output.

Why, here, are there a conflict with the rows not matching the join filter ? 

Is it not the principle of this type of join to only get the rows matching and discard the others ?

Thank you in advance.

[Anonymous]

Ok my bad TRF. You were right. I added a filter to get only the rows where date is not null and it's working as expected.

I don't really understand where the date can become null but the problem is solved so thank you !

[TRF]

Great!

Thank you for Kudo and to have marked your case as Solved.