How to handle division by zero error in tmap.
after applying col1/col2 in tmap i am getting below error.
Exception in component tMap_1
java.lang.ArithmeticException: / by zero
Note: col1 and col2 we have 0(Zero) values.
Solved! Go to Solution.
Assuming your expression is .....
...and assuming that if it is divided by 0 you want to return 0 (you can change this to whatever suits you), you can do this....
row1.col1==null || row1.col2==null || row1.col2.equals(0) ? 0 : row1.col1/row1.col2
I am also checking for nulls here, just in case.
I am tried below code,
row1.col1==null || row1.col2==null || row1.col2==0 ? 0 : row1.col1/row1.col2
because both are integer column type is integer.
It's worked for me.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.