Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
How to handle division by zero error in tmap.
src_cols
col1 integer
col2 integer
target_cols
col integer
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.
Thanks
shree
Great, would you accept the solution please?
Assuming your expression is .....
row1.col1/row1.col2
...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.
Hi @rhall,
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.
thanks
Shree
Great, would you accept the solution please?