topic Re: tmap update output string if input string is null in Talend Studio

tmap update output string if input string is null

Anonymous — Mon, 17 Dec 2018 21:09:34 GMT

Hey folks,

Please see pic attached. I am trying to catch if an input string is null if so I want to replace it with "Unknown" in the output row. I have tried several different ways but can't get it working any help is appreciated.

Neil.

Re: tmap update output string if input string is null

vapukov — Mon, 17 Dec 2018 22:01:46 GMT

hi Neil,

as described it must be

row5.Aligment==null?"Unknown":row5.Aligment

condition?true:false

in your case if null it continue to be null, and replace all not null

Re: tmap update output string if input string is null

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

Thanks very much worked perfectly!