Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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
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
@Houssem Jlassi , in tMap4, how many column are creating expressions other than direct fields you need to app for all.
Thanks,
Manohar
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