I want to perform below check for input column as if values in (String1,String1,String1..so on) then process else fail the Job

[Anonymous]

Hi Team,

I want to check column values against some hard code values and if values matches then proceed else fail the job with some user defined error in console. Please suggest the design.

I think this can be done tMap component in expression.

[fdenis]

hi,
yes you can use tmap with a validation expression and catching output results. then use twarn to log message.
have a look at:
https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/mxzKD~8eLuNFSXH6LMi7qg

good luck