topic Re: Null pointer exception in double datatype data. Need your inputs to fix this. in Talend Studio

Null pointer exception in double datatype data. Need your inputs to fix this.

SSV1 — Sat, 16 Nov 2024 00:03:45 GMT

Dear Talend Community,

Good day to all.

Extracting amount data from spreadsheet and providing datatype as double. While i am performing some calculations it throwing "Null pointer Exception issue".

Is there a way without ignoring the row and process the calculation. Could you please let me know fix for this issue.

Example:

Amount1 Amount2 Result(Addition)

10.00 10.00 20.00

10.00 10.00

ThankYou,

Sakthi

Re: Null pointer exception in double datatype data. Need your inputs to fix this.

Anonymous — Tue, 15 Jun 2021 02:12:20 GMT

There must exist Null value in source data. Can you show us the expression which you perform the calculations?

Regards

Shong

Re: Null pointer exception in double datatype data. Need your inputs to fix this.

SSV1 — Tue, 15 Jun 2021 04:11:02 GMT

Hi Shong,

Thank you for the reply. Yes you are right data has null. Below is the expression.

Amount1+Amount2 in the expression

ThankYou,

Sakthi

Re: Null pointer exception in double datatype data. Need your inputs to fix this.

Anonymous — Tue, 15 Jun 2021 06:09:01 GMT

change the expression to:

row1.Amount1==null?(row1.Amount2==null?0:row1.Amount2):(row1.Amount2==null?row1.Amount1:row1.Amount1+row1.Amount2)

Re: Null pointer exception in double datatype data. Need your inputs to fix this.

SSV1 — Tue, 15 Jun 2021 17:27:22 GMT

Hi Shong,

Thank You.

To handle this scenario first tmap check the column with relation null and handled it using below format.

Relational.ISNULL(columnname)?0:columnname

With this closing this topic. Thank you once again.

ThankYou,

Sakthi