topic Re: Using If Condition in Tmap in Data Quality

Using If Condition in Tmap

DY94 — Fri, 15 Nov 2024 23:18:56 GMT

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.

Re: Using If Condition in Tmap

kakooo16 — Thu, 13 Jan 2022 13:10:29 GMT

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

Re: Using If Condition in Tmap

DY94 — Thu, 13 Jan 2022 13:22:58 GMT

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.

Re: Using If Condition in Tmap

kakooo16 — Thu, 13 Jan 2022 13:36:58 GMT

here is a screenshot

Re: Using If Condition in Tmap

DY94 — Thu, 13 Jan 2022 13:55:40 GMT

Thanks ! It works.

Re: Using If Condition in Tmap

DY94 — Mon, 17 Jan 2022 08:22:02 GMT

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.

Re: Using If Condition in Tmap

kakooo16 — Mon, 17 Jan 2022 10:41:32 GMT

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

)

Re: Using If Condition in Tmap

DY94 — Mon, 17 Jan 2022 12:03:58 GMT

Thank you @not specified not specified