topic Re: tmap join on ID having NULL values in Talend Studio

tmap join on ID having NULL values

Parikhharshal — Sat, 16 Nov 2024 07:34:59 GMT

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.

Re: tmap join on ID having NULL values

Anonymous — Wed, 26 Sep 2018 05:45:12 GMT

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

Re: tmap join on ID having NULL values

manodwhb — Wed, 26 Sep 2018 06:31:01 GMT

@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.

Re: tmap join on ID having NULL values

Parikhharshal — Thu, 27 Sep 2018 04:23:51 GMT

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

Re: tmap join on ID having NULL values

manodwhb — Thu, 27 Sep 2018 05:30:26 GMT

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

Re: tmap join on ID having NULL values

Parikhharshal — Thu, 27 Sep 2018 05:31:34 GMT

NullpointerException.

Year is string whereas TP_Num is integer.

Re: tmap join on ID having NULL values

manodwhb — Thu, 27 Sep 2018 05:49:35 GMT

@Parikhharshal,what was the output field data type?

Re: tmap join on ID having NULL values

Parikhharshal — Thu, 27 Sep 2018 05:50:54 GMT

Manohar

I fixed this by fixing one of the expressions.

Thanks for your help.