Talend DI

Prakhar1 — Sat, 16 Nov 2024 03:59:18 GMT

Hi,

I have written a query on a table which gives me the following output,

job_name, active

a,0

b,1

c,0

Now I have to see that if any value for column active is 0, then i have to select the name of the job and send it via mail.

else if no column have 0 value then run other job.

If I check the 0 then i am not able to get the name of the jobs , any way to do both these check.

Regards,

Prakhar

Re: Talend DI

Anonymous — Thu, 28 Nov 2019 15:17:58 GMT

Hi,

In the first stage, send the input data to a tMap/tFilterRow to filter the records having 0. Then send this data to tAggregaterow and take the count of records. If the count is 0, it means none of the jobs is having 0 as active. Using a Runif condition, check the value and trigger the second job (if no column have 0 value then run other job).

Now, if there are rows with ) as active, send that data to the email component. You can send all the values in one shot or you an do it in iterative fashion (one job name at a time) using tFlowtoIterate.

Please try the flow and if you are stuck, I would recommend to add your job screenshots along with any errors.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

topic Talend DI in Talend Studio

Talend DI

Re: Talend DI