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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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