Convert String to Int with a condition

[EvoticTalend]

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]

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

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

Thanks,

Manohar

[EvoticTalend]

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 · Accepted solution]

try this expression:

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

[manodwhb]

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

Thanks,

Manohar

[EvoticTalend]

Thank You! Works perfectly.

[gjeremy1617088143]

Hi a simpler solution :

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

Send me Love and Kudos