topic Re: Convert String to Int with a condition in Talend Studio

Convert String to Int with a condition

EvoticTalend — Fri, 15 Nov 2024 23:59:46 GMT

Hello, I have a column said CLICKS (String) that might says "Yes" and other that are all null.

"Yes" values means 1

Null values means 0

EXAMPLE:

CLICKS

1 Yes

2 Yes

3 Null

4 Null

5 Yes

I need this column in INT with numbers because I want to calculate in a BI software later.

¿How can I convert this "Yes" values into a number 1? I need to convert to int and... -- IF (COLUMN CLICKS) COLUMN CLICKS = 1 --

manodwhb — Wed, 30 Jun 2021 10:43:43 GMT

@Ivan R , You need to use below way in tmap or tjavarow after reading data .

row1.CLICKS.equals("Yes") ? 1 : 0

Thanks,

Manohar

EvoticTalend — Wed, 30 Jun 2021 11:00:44 GMT

Thank you for the response.

I put this code in a row in a tMap but I have a "java.lang.NullPointerException" when I send to a SQL Server DB

Anonymous — Wed, 30 Jun 2021 11:32:00 GMT

try this expression:

row1.CLICKS==null?0:(row1.CLICKS.equals("Yes") ? 1 : 0)

manodwhb — Wed, 30 Jun 2021 11:34:16 GMT

@Ivan R ,Agree with @Shicong Hong ,it should work.

Thanks,

Manohar

EvoticTalend — Wed, 30 Jun 2021 11:40:47 GMT

Thank You! Works perfectly.

gjeremy1617088143 — Wed, 30 Jun 2021 12:06:09 GMT

Hi a simpler solution :

("Yes").equals(row1.CLICKS)?1:0;

Send me Love and Kudos