topic Re: Case statement using different columns in Talend Studio

Case statement using different columns

anushaya1512 — Sun, 28 Aug 2016 12:26:04 GMT

I have a case statement as below
Case when col1 like '%other%' then 'No' else col5 end as col5
Here like in SQL I need to implement the case statement with different columns and the wild card check of the word 'other' all in talend how can this be done?

Re: Case statement using different columns

Anonymous — Mon, 29 Aug 2016 03:54:39 GMT

Hi
In talend, you can write the expression on tMap like:
row1.col1.contains("other")?"No":row1.col5

Please refers to this KB article to learn more tMap expression syntax.

Regards
Shong

Re: Case statement using different columns

Anonymous — Sat, 08 Oct 2016 07:37:28 GMT

CASE is a function, and can only return a single value. I think you are going to have to duplicate your CASE logic.

The other option would be to wrap the whole query with an IF and have two separate queries to return results. Without seeing the rest of the query, it's hard to say if that would work for you. Take IT company in Kannur advice.