topic Re: Display error if tFilterRow results == 0 in Talend Studio

Display error if tFilterRow results == 0

Anonymous — Sat, 16 Nov 2024 07:47:14 GMT

I have a job in which I use a rowFilter based on a condition. It works. But, what I want to do more is to display an error or stop the job if the number of filtered rows is 0. How can I achieve that?

This is my job:

Does anyone could help me?

Thank you in advance.

Re: Display error if tFilterRow results == 0

TRF — Wed, 22 Aug 2018 15:15:54 GMT

Check for tFilterRow_1_NB_LINE_OK global variable after the component (change 1 to reflect the real number for your component).

Re: Display error if tFilterRow results == 0

Anonymous — Wed, 22 Aug 2018 15:32:08 GMT

I put tSetGlobalVariable after tFilterRow_1. In Value I wrote ((integer)globalMpa.get("tFilterRow_1_NB_LINE_OK")).intValue(), but how can I stop the job if the result is 0? I need to catch it.

@TRF wrote:
Check for tFilterRow_1_NB_LINE_OK global variable after the component (change 1 to reflect the real number for your component).

Re: Display error if tFilterRow results == 0

Anonymous — Wed, 22 Aug 2018 15:59:49 GMT

hi Emanuele89,

You could use the Run if Trigger and give the condition as ((Integer)globalMap.get("tFilterRow_1_NB_LINE"))>0 condition followed by the logic you want to incorporate

Thanks,

RekhaSree

Re: Display error if tFilterRow results == 0

Anonymous — Wed, 22 Aug 2018 16:23:58 GMT

I solved it! I linked tFilterRow > run if > tDie

@Emanuele89 wrote:

I put tSetGlobalVariable after tFilterRow_1. In Value I wrote ((integer)globalMpa.get("tFilterRow_1_NB_LINE_OK")).intValue(), but how can I stop the job if the result is 0? I need to catch it.

@TRF wrote:
Check for tFilterRow_1_NB_LINE_OK global variable after the component (change 1 to reflect the real number for your component).

Re: Display error if tFilterRow results == 0

TRF — Wed, 22 Aug 2018 17:02:34 GMT

Great!
Don't forget to mark your case as solved (Kudo also accepted).