topic Re: Conditional Processing in Talend Studio

Conditional Processing

jimbo20814 — Sat, 16 Nov 2024 03:00:47 GMT

All, what would be the best way to accomplish this?

First, I need to check error logs at database table. I was going to store the count in context variable. If the count is > 0, job processing should not occur. How can I conditionally control the execution of a job according to value from a context variable?

Re: Conditional Processing

TRF — Wed, 11 Mar 2020 20:11:49 GMT

Connect a tJava and a tRunJob with a "if" link.
Let the tJava as is.
Enter the desired condition for the "if" link like this: context.counter == 0
This way tRunJob will start only if context.counter is equal to 0.

Re: Conditional Processing

jimbo20814 — Wed, 11 Mar 2020 20:20:13 GMT

Thanks TRF. But I'm wondering if I even need context to hold the counter. Can the If link come directly from the tDBInput? If so what would the code look like? The tDBInput only has one integer output, ErrorCount. I tried simply ErrorCount == 0 inside the If, but it says ErrorCount cannot be resolved to a variable.

Re: Conditional Processing

TRF — Wed, 11 Mar 2020 20:59:02 GMT

rowx.ErrorCount == 0