How to convert this sql case statement for tmap

[RAJ6]

Hi talend folks,

How to convert this sql case statement for tmap  

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

[TRF]

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]

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