topic Stop Job on no value in Talend Studio

Stop Job on no value

EGuarato1648206044 — Fri, 15 Nov 2024 22:58:57 GMT

Hello, I want to put some restriction and stop the process in case of no value. (not null value).

So i want to check:

1) if a quey in the component t_DBInput doesn't return anything -> t_Die, else goes on.

2) if a t_FileFetch can't get the file -> t_Die else goes on.

I tried to use the t_SchemaComplianceCheck but it seems checking on Null value, not on no value at all. Or maybe the component is the right one but i'm using it in the wrong way.

Re: Stop Job on no value

Anonymous — Thu, 28 Apr 2022 02:37:34 GMT

For 1), there is a global variable that counts the total number of records are returned, you can use this variable as condition, eg:

tDBInput--tJavaRow( or other components)---runIf--tDie

set the condition of runIf as:

((Integer)globalMap.get("tDBInput_1_NB_LINE"))==0

For 2), just check the 'die on error' box? does the component has an error if no file is fetched?

Regards

Shong

Re: Stop Job on no value

gjeremy1617088143 — Fri, 29 Apr 2022 09:17:58 GMT

Hi, for tSchemaComplianceCheck you have an option in advanced settings of the component named Treat all empty string as NULL,

if you check this one and set a non null column then the component will reject null value and empty value for a String.