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.
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