Hi Talend Folks,
I need to convert the below SQL case statement While using tmap component in talend
when t1.NET < 0
end)) AS NET
You can use the tMap variables and do your query using the Talend's condition :
In your case, you will create variable which value is t1.NET*-1 if t1.NET < 0 else t1.NET and after you will map your variable to the ouput and add the sum function to the variable.