if/Else condition and switch case in TOS

Anonymous — Sat, 16 Nov 2024 04:48:33 GMT

How to implement following SQL Statement in TOS using TMAP (using IF else or switch)

Case
When T1.last_time between @gone_start_int and @gone_end_int Then 'Goneaway'
When T1.last_time between @LPD_start_int and @LPD_end_int Then 'Lapsed'
When T1.first_time between @start_date_int and @end_date_int Then 'New' --New customers
Else 'RFV' --active customers
End as 'RFM_Segment'

Re: if/Else condition and switch case in TOS

TRF — Sat, 31 Aug 2019 15:09:46 GMT

If you want to use if/else, tJavaRow component is what you need. Within tMap you case use ternary notation.

topic Re: if/Else condition and switch case in TOS in Talend Studio

if/Else condition and switch case in TOS

Re: if/Else condition and switch case in TOS