topic Re: tMap if statement in Talend Studio

tMap if statement

Anonymous — Mon, 18 Feb 2019 20:32:42 GMT

Hello,

I am new to Talend and trying to write a pretty simple if statement in the tmap to translate a text field to a booleen. The input will be sending a "Y" or "N" and I have to convert it to True or False for the conversion. I have it written like this: IF(row1.shut == "Y", true, false) When I run my job, I get an error: The Method IF(boolean, boolean, boolean) is unidentified fro the type account. I appreciate any insight!

Re: tMap if statement

TRF — Mon, 18 Feb 2019 20:40:45 GMT

You cannot write an "if" statement into the tMap component.

You have to use a ternary expression like this one:

"Y".equalsIgnoreCase(row1.shut) ? true : false

Re: tMap if statement

Anonymous — Mon, 18 Feb 2019 20:45:22 GMT

If Y and N are string

Please follow below steps

row1.shut.toLowercase().contains("Y")

"True"

"False"

But before doing that you should do null check so that only you will get Y or N to output side

Re: tMap if statement

Anonymous — Tue, 19 Feb 2019 14:11:56 GMT

Thank you both! Both solutions worked. Guess I better brush up on my conversions. Got a bunch to convert to doubles. I appreciate the help.

Re: tMap if statement

TRF — Tue, 19 Feb 2019 20:20:58 GMT

@steeld95 thanks to mark tour case as solved