Talend DI

[Prakhar1]

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

[Anonymous]

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