topic If-else condition formula help in Talend Studio

If-else condition formula help

Anonymous — Thu, 26 Apr 2018 20:12:44 GMT

Hi,

I have a below table.

Stage_Name Closedate

Close Won 11/30/2016

Close Lost 03/05/2016

Active 10/06/2017

so I have to write a condition in my Tmap that if my stage_name= Close Won or Close Lost , then Closedate = 01/01/2018 else keep same value of closedates.

How do I put that condition in tmap..?

Re: If-else condition formula help

Shettydatta — Thu, 26 Apr 2018 20:51:02 GMT

Put an expression as

! Stage_Name.equals("Active") ? "01/01/2018" : Closedate

Re: If-else condition formula help

manodwhb — Fri, 27 Apr 2018 02:27:41 GMT

!row1.Stage_Name.equals("Active") ? "01/01/2018" : row1.Closedate