topic Re: Problem in tMap formula : condition if ... else in Talend Studio

Problem in tMap formula : condition if ... else

Anonymous — Wed, 25 Oct 2017 12:22:16 GMT

Dear experts,

I have an issue with this formula in my tMap :

row2.status == "PRE_TXT" ? 1 : row2.status == "TXT" ? 2 : -1

In fact, it's only return -1 whereas I have the values : "PRE_TXT" and "TXT" in my source field.

Many thanks. Best regards

Anonymous — Wed, 25 Oct 2017 12:42:58 GMT

I've found the solution :

row2.status.equals("PRE_TXT")?1:row2.status.equals("TXT")?2:-1

Anonymous — Wed, 25 Oct 2017 13:07:31 GMT

Removed my post, as I'd made a mistake regarding Java operator precedence. Sorry.

Comparing the value of strings using .equals() is guaranteed to work in all cases, and that's specifically what it's designed to do.

Anonymous — Wed, 25 Oct 2017 14:09:51 GMT

Thank you for these explanations

Best regads