topic Re: How to convert this sql case statement for tmap in Talend Studio

How to convert this sql case statement for tmap

RAJ6 — Sat, 16 Nov 2024 08:34:41 GMT

Hi talend folks,

How to convert this sql case statement for tmap

case
when CHL= 'S' then date_trunc('day',"DATE")
end DATE

TRF — Sat, 10 Mar 2018 17:20:00 GMT

Hi,

To have the result as a date try this:

row1.CHL == 'S' ?
 TalendDate.parseDate("dd/MM/yyyy", TalendDate.formatDate("dd/MM/yyyy", row1.yourField))) : row1.yourField

Hope this helps.

TRF — Sun, 11 Mar 2018 07:52:49 GMT

Did this help?
If so, thank's to mark your case as solved.