The Definitive Guide to Data Quality
if your input columns are 1/0 boolean values, set your schema types to Boolean.
then the expression would be something like:
for output column TYPETEXT: row3.TYPETEXT || "Text"
for output column TYPEUPPS: row3.TYPEUPPS || "Supplement"
for output column TYPEMEDIA: row3.TYPEMEDIA || "Media"
row3.TYPETEXT == null ? null : row3.TYPETEXT || "Text"
the "cannot be resolved" error is because you are referencing a variable that does not exist (or is out of scope) if you are doing this in a tMap, make sure that you do in fact have a row3.TYPEUPPS in your input table.
It looks like you're struggling with basic java and ternary syntax. Please take a look at these pages to help you debug your statements:
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend
Test drive Talend's enterprise products.