topic Re: Ternary notation help needed... in Talend Studio

Ternary notation help needed...

Anonymous — Wed, 25 Oct 2017 14:31:59 GMT

I am trying to create a variable in the tMap component, which will allow me to test the contents of two input fields from tOracleInput, and output a 1 or 0 based on the result.

I've used a number of variations of notation but none of the,m seem to be giving me the result I expect (and know). Can anyone advised what I need to change in the below:

(FirstOfMonth.VEHICLE_DRIVEABLE=="N"&&FirstOfMonth.BOOKING_IN_DATE!=null)?1:0

Thanks in advance.

Re: Ternary notation help needed...

TRF — Wed, 25 Oct 2017 14:36:39 GMT

Hi,

You should never compare 2 strings using the "==" operator:

("N".equals(FirstOfMonth.VEHICLE_DRIVEABLE) && 
 FirstOfMonth.BOOKING_IN_DATE != null) ? 1 : 0

Hope this helps.

Re: Ternary notation help needed...

Anonymous — Wed, 25 Oct 2017 15:08:36 GMT

Legend - works a treat.

Thanks very much!