topic Fail the job when no rows returned in Talend Studio

Fail the job when no rows returned

Anonymous — Fri, 13 Jul 2018 00:57:28 GMT

Hi,

I'm new to Talend.

I'm looking to create job where it exits (or fails with return code 1) when no rows are returned and succeeds if there's data in source table.

I tried a couple of approaches but they're not working. appreciate if someone can help me.

Anonymous — Sat, 14 Jul 2018 03:41:21 GMT

You can use a tDie to die the job and customize the error message and error code. eg;

tMysqlInput--main--tJavaRow

-runIf--tDie

Set the condition of runIf as:

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

Regards

Shong