topic Re: Tmap entering 0 for output for null integer input in Talend Studio

Tmap entering 0 for output for null integer input

Anonymous — Mon, 17 Dec 2018 22:41:20 GMT

Hey folks,

I have the code below trying to set 0 for input integer row where the value is null but I still have null value on output. Any help is much appreciated.

Marvel_TV.Cartoonshows ==null||Marvel_TV.Cartoonshows .equals("")?null:new Integer(Marvel_TV.Cartoonshows)

Cheers,

Neil.

Re: Tmap entering 0 for output for null integer input

vapukov — Tue, 18 Dec 2018 00:03:06 GMT

your logic translated to plain english look like:

- if any of 2 (Marvel_TV.Cartoonshows==null or |Marvel_TV.Cartoonshows is empty) - use null, if no one of them - use new Integer(Marvel_TV.Cartoonshows)

is this logic correct or you must change it?

Marvel_TV.Cartoonshows==null||Marvel_TV.Cartoonshows .equals("")?0:new Integer(Marvel_TV.Cartoonshows)

Re: Tmap entering 0 for output for null integer input

Anonymous — Tue, 18 Dec 2018 00:05:45 GMT

Thats perfect thanks again your help is much appreciated!