topic Re: Tmap expression output isnt whats expected (even from tester) in Talend Studio

Tmap expression output isnt whats expected (even from tester)

Anonymous — Wed, 06 Mar 2019 01:54:17 GMT

Hello I have the following expression and when I have Min and Max == or != to each other in the tester, I get "Exception in thread "main" java.lang.Error: Unresolved compilation problems:"

SET_VALUES.AddrMin == SET_VALUES.AddrMax ? null
: SET_VALUES.AddrMin != SET_VALUES.AddrMax ? SET_VALUES.Count + SET_VALUES.ModuleWidth
:null

However, When I run my job anyway, my results show that is works when Min != Max (it does the calculation properally) However, it doesn't set the output to null if the min == max. Please help!

Re: Tmap expression output isnt whats expected (even from tester)

manodwhb — Wed, 06 Mar 2019 04:11:54 GMT

@dutch070 ,you need to change the expression below way. this will work check this.

SET_VALUES.AddrMin != SET_VALUES.AddrMax ? SET_VALUES.Count + SET_VALUES.ModuleWidth
:null

Re: Tmap expression output isnt whats expected (even from tester)

manodwhb — Wed, 06 Mar 2019 05:33:45 GMT

@dutch070 ,input column data type should be integer.

Re: Tmap expression output isnt whats expected (even from tester)

Anonymous — Wed, 06 Mar 2019 16:33:44 GMT

So It has to be at least a decimal for me because my data set has them. I have it set as datatype double. Math should still work out the same though right?

I tried both expressions and neither worked. for me.

Talend Help.png

Re: Tmap expression output isnt whats expected (even from tester)

Anonymous — Wed, 06 Mar 2019 16:42:54 GMT

Here Is a screen shot of my Tmap.

Talend Help2.png

Re: Tmap expression output isnt whats expected (even from tester)

Anonymous — Wed, 06 Mar 2019 17:39:54 GMT

I ended up changing the data type to Big Decimal and then the following expression worked. For some reason, adding doubles doesn't work very consistently. Thanks!

row6.AddrMin.equals(row6.AddrMax) ? null
: row6.AddrMin.add(row6.MinW)