IF ELSE condition for integer and decimal

zalibra — Wed, 11 Dec 2019 15:25:46 GMT

Trying to figure out how the IF/ELSE statement should be structured in tMap when trying to filter integers and decimals (I know how to do it for String and Date, but can't seem to figure out for numbers).

I've used the below for now and it works, but trying to see if there's another method where I can specify directly "IF integer, accept value, ELSE null"

row1.field1 % 1 == 0 ? row1.field1 : null

Re: IF ELSE condition for integer and decimal

TRF — Wed, 11 Dec 2019 15:48:38 GMT

Ternary notation (what you're using) is the solution to replace IF/ELSE into tMap.

topic IF ELSE condition for integer and decimal in Talend Studio

IF ELSE condition for integer and decimal

Re: IF ELSE condition for integer and decimal