tmap join on ID having NULL values

[Parikhharshal]

Hi Talend experts

I was wondering if it is possible to join on ID having NULL values.

My tMap is failing and receiving Nullpointerexception. 

I am doing something like this:

ID in row4 is NULL which I am trying to join with row1 Account__c. There is no way I can skip those Null values in row4. 

Can someone suggest some solution by which I can avoid this situation?

Thanks

Harshal.

[Anonymous]

Hi,

     Could you please share the job flow and the error log you are getting? The issue root cause might be somewhere else in the job.

Warm Regards,

Nikhil Thampi

[manodwhb · Accepted solution]

@Parikhharshal, it is not problem with the join columns ,it is problem the expression if you have written to any output column,which need to be handle nulls fist and then expression.

[Parikhharshal]

Hi Manohar

I have got problem in this expression.

(row4.Unit_start_TP_Num!= null) || (row4.Year__c != "Unknown") && (row4.Unit_start_TP_Num >0) ?
row4.Year__c +Integer.toString(row4.Unit_start_TP_Num) : "-2"

Not sure what's the problem.

Can you please help me?

Thanks
Harshal

[manodwhb]

@Parikhharshal,what was the error? what was the data type of row4.Unit_start_TP_Num and row4.Year__c?

[Parikhharshal]

NullpointerException.

Year is string whereas TP_Num is integer.

[manodwhb]

@Parikhharshal,what was the output field data type?

[Parikhharshal]

Manohar

I fixed this by fixing one of the expressions.

Thanks for your help.