Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

 

 

0683p000009M3zK.png

 

 

 

 

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@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

 

View solution in original post

3 Replies
manodwhb
Champion II
Champion II

@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

 
Anonymous
Not applicable
Author

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

manodwhb
Champion II
Champion II

@shaneacara ,check0683p000009M3zZ.png below screenshot.