Q:

Case statement using different columns in Talend

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? 

A:

If the columns are not dynamically created, you can add a case in tMap for example.
So, for a new boolean column you could create the expression:
row1.mycolumn1.toLowerCase().contains("other") ? new Boolean.true : new Boolean.false;

The boolean field would hold the check value then.
EDIT 
Since a new boolean column is not wanted here, your specific requirement would look like this:
row1.product_code.toLowerCase().contains("other") ? "No data" : row1.product_code;

