Display error if tFilterRow results == 0

[Anonymous]

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.

[TRF]

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

[Anonymous]

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).

---

[Anonymous]

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

.

[Anonymous · Accepted solution]

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).

---

---

[TRF]

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