topic Re: how to use nested if condition in tmap in Talend Studio

how to use nested if condition in tmap

Anonymous — Sat, 16 Nov 2024 11:41:14 GMT

I have one decode. I want to convert it into if-else condition of talend in tmap
decode(v_DURATION,'PERPETUAL',NULL,NULL,NULL,'Duration:' ||v_DURATION)

Thanks in advance,
Kiran.

Re: how to use nested if condition in tmap

willm1 — Thu, 10 Apr 2014 15:17:14 GMT

Kiran - let me give this a stab... In plain English, here's what your statement translates to:
if v_DURATION = PERPETUAL then Null
else if v_DURATION = Null then Null
else 'Duration:' ||v_DURATION
Using ternary operators in tMap, the standard is "test condtion ? true : false"
row1.v_DURATION !=null && !row1.v_DURATION.isEmpty() ? (row1.v_DURATION.equals("PERPETUAL")? null : row1.v_DURATION.equals("NULL")? NULL : "Duration: " + row1.v_DURATION) : ""
To avoid the pervasive nullpointer exception, I first check to make sure v_Duration has a non-Null value...

Re: how to use nested if condition in tmap

Anonymous — Thu, 10 Apr 2014 15:47:21 GMT

thanx willm