How to implement following SQL Statement in TOS using TMAP (using IF else or switch)
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'
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema