Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
gt0731
Contributor III
Contributor III

How do i use Talend If-then-else for diffrent cases.

Hello Team,
Greetings to all of You!
I am  trying to write this expression  into talend tmap component .  How to write this expression into tmap  component expression builder using ternary operator.

case when ='(00) PRE-PAID' then '00'when='(01) C.O.D.' then '(01) C.O.D'when='(02) EOM' then '02'when='10' then '(10) NET 10 DAYS'when='15' then '(15) NET 15 DAYS'when='21' then '(21) 2 % 30 NET 31'when='23' then '(23) 2% NET 30 DAYS'when='3' then '(3) CHECK'when='30' then '(30) NET 30 DAYS' else end as TCode



Thanks in Advance !

Labels (2)
10 Replies
Anonymous
Not applicable

If

                Trim(( IF IsNotNull((ffr_dcconso_ref_initial.TITLE)) THEN (ffr_dcconso_ref_initial.TITLE) ELSE (""))) <> ""

then 

                if

                Trim(( IF IsNotNull((ffr_dcconso_ref_initial.TITLE)) THEN (ffr_dcconso_ref_initial.TITLE) ELSE (""))) = "1"

                then "MR"

                else               

else ""

 

--FLAG