Using If Condition in Tmap

[DY94]

Dear Community,

I need to do this condition in Tmap:

if row.int_rate == 3

then row.int_rate = row.int_spread + row.taux_base

else

row.int_rate = row.int_rate

Thank you.

[kakooo16 · Accepted solution]

!Relational.ISNULL(row3.int_rate) && (row3.int_rate == 3) ?row3.int_spread + row3.taux_base : row3.int_rate 

[DY94]

Hi kakooo16,

Thank you for answer !

I got just one error in this line " row.int_rate = row.int_rate "

its says " syntax error on token '=' "

Thanks.

[kakooo16]

here is a screenshot

[DY94]

Thanks ! It works.

[DY94]

Hi @not specified not specified​,

The code works fine but i got " NullPointerException" Error !!

this is my final Code:

(Float)

(

(row4.INT_RATE_TYPE== 3) && (!Relational.ISNULL(row4.INT_RATE_TYPE) ) ? row4.INTEREST_SPREAD + row4.TAUX_BASE : row4.INTEREST_RATE

) 

Thanks.

[kakooo16]

try this

(

(row4.INT_RATE_TYPE== 3) && (!Relational.ISNULL(row4.INT_RATE_TYPE) && (!Relational.ISNULL(row4.INTEREST_SPREAD ) && (!Relational.ISNULL(row4.TAUX_BASE ) ) ? row4.INTEREST_SPREAD + row4.TAUX_BASE : row4.INTEREST_RATE

) 

[DY94]

Thank you @not specified not specified​