topic Re: Missing something easy with this conditional in Talend Studio

Missing something easy with this conditional

Anonymous — Thu, 29 Aug 2019 17:29:52 GMT

Hi All,

In tMap I have the following expression:

StringHandling.TRIM(row2.country) == "Germany"?"EMEA":"UNKNOWN"

But for some reason all the values, regardless of the value of "row2.country" are all coming up as "UNKNOWN" including the ones that have a value of "Germany".

I have checked the incoming data and it is correct (initialized just like in the equation).

I am sure I am missing something simple but it is escaping me.

Thanks.

Re: Missing something easy with this conditional

nivedhitha — Thu, 29 Aug 2019 17:47:39 GMT

@Craigbert ,

Please try changing the condition to

StringHandling.TRIM(row2.country).equals("Germany")?"EMEA":"UNKNOWN"

and see if it works.

For strings, it is usually done this way

Re: Missing something easy with this conditional

Anonymous — Thu, 29 Aug 2019 17:54:53 GMT

String value comparison should be done with .equals() method and not == operator. Double equals is for object reference comparison

Re: Missing something easy with this conditional

Anonymous — Thu, 29 Aug 2019 18:54:22 GMT

Thanks to you both! That solved my problem!