topic Re: How to handle division by zero error in tmap. in Talend Studio

How to handle division by zero error in tmap.

Anonymous — Tue, 26 Jun 2018 15:22:05 GMT

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

Anonymous — Tue, 26 Jun 2018 15:49:12 GMT

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.

Anonymous — Tue, 26 Jun 2018 17:12:39 GMT

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

Anonymous — Wed, 27 Jun 2018 16:03:33 GMT

Great, would you accept the solution please?