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)
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...
