topic Re: How to use below SQL case statement While using tmap component in Talend Studio

How to use below SQL case statement While using tmap component

RAJ6 — Tue, 25 Jul 2017 07:34:23 GMT

Hi Talend Folks,

I need to convert the below SQL case statement While using tmap component in talend

(SUM(case
when t1.NET < 0
then (t1.NET*-1)
else
t1.NET
end)) AS NET

Re: How to use below SQL case statement While using tmap component

TRF — Tue, 25 Jul 2017 08:52:17 GMT

Hi,

Just get the absolute value of NET field:

Hope this helps.

Re: How to use below SQL case statement While using tmap component

med1 — Tue, 25 Jul 2017 15:43:22 GMT

Hello,

You can use the tMap variables and do your query using the Talend's condition :

row1.myKey.equals("FirstValue")?1:0

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.

Thanks,

Med

Thanks,

Med