topic Re: Conditional expression in tmap in Talend Studio

Conditional expression in tmap

EvoticTalend — Fri, 15 Nov 2024 23:41:27 GMT

Hi everyone!

I have a column with this possible values:

N/A

I want it as an INT, so I have to transform this N/A values... I already have this code in the tmap:

row1.XXX.equals("N/A")?0:1

How would be the real code to transform this N/A to 0 and convert the column to int? THANKS YOU

MattE — Mon, 27 Sep 2021 14:35:54 GMT

if row1.XXX is a string check it's not null or empty first

(!Relational.ISNULL(row1.XXX) && !"".equals(row1.XXX)?row1.XXX.equals("1")?1:0:0)

However, that error you're getting makes me think that either row1.XXX is not a string in tMap or that the out row is not set to Integer.

EvoticTalend — Tue, 28 Sep 2021 15:04:38 GMT

Hi! In your code how can i put the "N/A" string?

Because the error still persist here for the "N/A" in an int column. I wanna say if the columns has null, blank or N/A = 0, else 1.

Thanks!