Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
!Relational.ISNULL(row3.int_rate) && (row3.int_rate == 3) ?row3.int_spread + row3.taux_base : row3.int_rate
!Relational.ISNULL(row3.int_rate) && (row3.int_rate == 3) ?row3.int_spread + row3.taux_base : row3.int_rate
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.
here is a screenshot
Thanks ! It works.
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.
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
)
Thank you @not specified not specified