Six Stars

How to handle division by zero error in tmap.

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

1 ACCEPTED SOLUTION

Accepted Solutions
Fifteen Stars

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

Great, would you accept the solution please? 

Rilhia Solutions
3 REPLIES
Fifteen Stars

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

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.

Rilhia Solutions
Six Stars

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

Hi @rhall_2_0,

 

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 

Fifteen Stars

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

Great, would you accept the solution please? 

Rilhia Solutions