topic How to Kill/Abort a Job when a field is NULL in Talend Studio

How to Kill/Abort a Job when a field is NULL

Anonymous — Wed, 27 Mar 2019 05:30:57 GMT

Hi,

I am new to talend..... In the input "UserSample", there is a column called "User" which contains two null values. I have already figured how to show an error message when the "User" column contains a null.

ALTHOUGH

What I want is to KILL or ABORT the job if it reads that there is a null in the column "User". The job shall discontinue which results to not executing the tFileOutputDelimited_1 at all.

Re: How to Kill/Abort a Job when a field is NULL

manodwhb — Wed, 27 Mar 2019 06:49:39 GMT

@shaneacara ,you can validate the schema using tSchemaComplianceCheck,which will only pass the valid records which you have defined in tSchemaComplianceCheck.check below link to know about this componnet.

https://help.talend.com/reader/2BxPaYP2sbd1RyAzSH52jg/lG3tgvF_vic_N2YHXbaa~w

Re: How to Kill/Abort a Job when a field is NULL

Anonymous — Wed, 27 Mar 2019 07:18:40 GMT

after the validation, how will I continue with the kill/abort process if there is a NULL?

Re: How to Kill/Abort a Job when a field is NULL

manodwhb — Wed, 27 Mar 2019 09:23:50 GMT

@shaneacara ,check below screenshot.