Null Pointer Exception after tAggregateRow

[HJlassi1619437866]

Hello, hope you're doing well,

I have a job to read data, transform it, aggregate two columns and then load data in informix database

tdbinput ---> Tmap ---> TaggregateRow ---> Tmap ---> tdboutput

columns are :

Client_Id

First_Name

Last_Name

Sexe

Age

Salary

Annual balance

tAggregateRow are working on salary and annual balance groupby id client

I get null pointer exception between tAggregateRow and Tmap

Please your answers will truly help me, thank you

[manodwhb]

@Houssem Jlassi​ ,you are getting null pointer exception in tMap, where you trying some expression without handling nulls.

example:-

row1.col1==null || row1.col2==null?0:(row1.col1*row1.col2)

Thanks,

Manohar

[HJlassi1619437866]

Thank you for your reply, but i added a condition to test if my flow is null then replace it by -1

but i still get this error

[manodwhb]

@Houssem Jlassi​ , in tMap4, how many column are creating expressions other than direct fields you need to app for all.

Thanks,

Manohar

[kakooo16]

Try using this :;

Relational.ISNULL(row6.column) ? -1 : row6.column if it is integer

Relational.ISNULL(row6.column) ? '-1' : row6.column if it is string .

Regards .

Amine