topic Re: java.lang.NullPointerException in Talend Studio

java.lang.NullPointerException

BSajjad1615375415 — Mon, 24 May 2021 08:45:17 GMT

Exception in component tMap_3 (pcrfvspgwsmalldata)

java.lang.NullPointerException

at newproj.pcrfvspgwsmalldata_0_1.pcrfvspgwsmalldata.tFileInputDelimited_4Process(pcrfvspgwsmalldata.java:3903)

at newproj.pcrfvspgwsmalldata_0_1.pcrfvspgwsmalldata.runJobInTOS(pcrfvspgwsmalldata.java:7434)

at newproj.pcrfvspgwsmalldata_0_1.pcrfvspgwsmalldata.main(pcrfvspgwsmalldata.java:7283)

Lines from the code:

Var.Variance = row6.Sum - row4.Diff;// # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

tFileInputDelimited_4Process(globalMap);

int exitCode = pcrfvspgwsmalldataClass.runJobInTOS(args);

The tmap function is doing a join between two data sets and difference between values of two columns

Re: java.lang.NullPointerException

gjeremy1617088143 — Mon, 24 May 2021 08:57:42 GMT

Hi, maybe row6.Sum or row4.Diff have null value.You have to make it null safe

Send me Love and kudos

Re: java.lang.NullPointerException

BSajjad1615375415 — Mon, 24 May 2021 09:20:44 GMT

Sum and Diff columns are float type. How do I make them null safe?

Re: java.lang.NullPointerException

gjeremy1617088143 — Mon, 24 May 2021 09:21:40 GMT

use Float instead of float

check null value for each and if one of them is null, reject it or pass a null value instead of the difference

Re: java.lang.NullPointerException

gjeremy1617088143 — Mon, 24 May 2021 09:25:25 GMT

(row6.Sum == null || row4.Diff == null)?null:row6.Sum - row4.Diff;

float are not good for precision , you'll better use other type like bigDecimal for example.

Re: java.lang.NullPointerException

BSajjad1615375415 — Mon, 24 May 2021 18:24:17 GMT

Thanks so much. This removed the error.

But I want the output like 6-null=6,

similarly, null-6=-6

null should be replaced with 0 in row6.Sum and row4.Diff

Re: java.lang.NullPointerException

gjeremy1617088143 — Mon, 24 May 2021 18:40:50 GMT

(row6.Sum ==null?0F:row6.Sum)-(row4.Diff==null?0F:row4.Diff);

Re: java.lang.NullPointerException

BSajjad1615375415 — Tue, 25 May 2021 08:31:01 GMT

Thanks . I was doing the same thing but with 0 not 0F. That was obviously giving type mismatch errors.

Re: java.lang.NullPointerException

gjeremy1617088143 — Tue, 25 May 2021 08:34:07 GMT

0f ,0F, new float(0),new Float(0) can work

Re: java.lang.NullPointerException

BSajjad1615375415 — Tue, 25 May 2021 08:40:13 GMT

Is there a way to pivot total of values in Talend.

For example, for 'ID' cloumn that has XX123, XX123 entries, I want sum of all values in column 'Volume' pertaining to XX123 ID.

Excel attached

Re: java.lang.NullPointerException

gjeremy1617088143 — Tue, 25 May 2021 08:48:07 GMT

tAggregateRow will do the job :

https://help.talend.com/r/rqVGdHtCwjLQfXwWricOzQ/ksr5r6HxwTSnbN7_ggQWLg