topic Re: Cannot Boolean to Integer in Talend Studio

Cannot Boolean to Integer

rwnetwork — Tue, 02 Jun 2020 20:47:55 GMT

Hi there,

Anyone know why this is error is occuring with my simple expression in my tmap? I'm confused. I have an integer input going to an integer output and it's bringing in an error about Boolean types? I just want to return the date that is >= another date. Please if anyone can help, I'm on a deadline. Thank you Community!

Re: Cannot Boolean to Integer

akumar2301 — Tue, 02 Jun 2020 20:53:33 GMT

Your expression returns a boolean ( >=) and then you joining it with an integer

You can try like ( syntax no correct)

(Minratedate >= miratedate) ? 1 : 0

Re: Cannot Boolean to Integer

rwnetwork — Tue, 02 Jun 2020 21:25:48 GMT

Thanks Abhishek! Let me try this in my design.

It worked! Thanks again.

Re: Cannot Boolean to Integer

rwnetwork — Wed, 03 Jun 2020 17:06:59 GMT

Hi again,

I realized that this didn't work 100%. This is what I'm using in my tmap, however, values returns are 0's and they are supposed to have dates.

Thoughts?

Anyone? Please and thank you.

Re: Cannot Boolean to Integer

akumar2301 — Wed, 03 Jun 2020 17:23:48 GMT

if you need date in integer format , you need to convert youe expressions output accordingly.

booleanExpression ? IfTrueExpression : IfFalseexpression

Re: Cannot Boolean to Integer

rwnetwork — Wed, 03 Jun 2020 19:08:28 GMT

Thanks, so are you saying that I still need to convert the whole Boolean expression to my needed data type, which is integer?

makethisInteger(booleanExpression)

Re: Cannot Boolean to Integer

akumar2301 — Wed, 03 Jun 2020 19:18:49 GMT

check ternary operator documentation , you will get more idea .
Try this :
https://www.geeksforgeeks.org/java-ternary-operator-with-examples/