topic Re: Tmap conditions working in test but not when executing in Talend Studio

Tmap conditions working in test but not when executing

daez — Fri, 04 May 2018 15:26:36 GMT

Hello everyone,

I'm fronting something strange with my Tmap conditions.
I have one row in input; with field "State". This state is a string : "in stock", all my input "State" has this value. I want it to be in the output 1 if its "in stock" and 0 for any others values. So i created a var with expressions :

row7.State=="in stock"?"1":"0"

named NewState, and linked it to my output " State". Before that, in the expression constructor, I did a test. I put as value " in stock" in row.7 state, clicked " Test " and it returned "1". I thought all was fine. But when I execute my job, all my state get "0".

How comes the Tmap Expression Builder's Test returns me the good value, but the output filed I get is false? What am I missing?

Re: Tmap conditions working in test but not when executing

TRF — Fri, 04 May 2018 15:29:50 GMT

You should never use == to compare 2 strings.

Use

"in stock".equalsIgnoreCase(row7.State) ? "1" : "0"

Re: Tmap conditions working in test but not when executing

daez — Fri, 04 May 2018 15:34:27 GMT

Thanks a lot TRF, learning every day here.

Solved.

Re: Tmap conditions working in test but not when executing

TRF — Fri, 04 May 2018 15:44:45 GMT

You're welcome