how to terminate tFlowToIterate

[Anonymous]

Hi,
I am new to Talend and I need help with tFlowToIterate...
I have a talend job with the following components:

MySQLInput(extract records) -> tFlowtoITerate(column id) ->tJavaRow(To check if records from MySQLInput are valid)->RunIF (run if valid) -> mySQLOutput (insert recrods) - > send mail (email alert that new rows were inserted)

When I run this, if for example I have a total of 20 records extracted and 10 records a valid, everything from tJavarow including the send mail component will execute ten times. With this, I will receive ten email alerts. I only want the send email component to run/execute after tFlowtoIterate has completed with its iteration/loop so I only get to receive one email notification.

The problem is I don't know how to this in Talend. Please help.

Thank you!

[Anonymous]

Hi,
Are you using OnsubjobOk connector between your tmySQLOutput and tsendmail component? Could you please post your current job design screenshot into forum?
Best regards
Sabrina

[Anonymous]

hi!

Thanks for the reply. Nope, I am not using OnsubjobOk , I am using OnComponentOk. Please see below. The SendMail component should run only once, i.e., after the process has completed the iteration. Btw, I am using Open Studio.

[Anonymous]

hello everyone! just wanted to ask for some help on this. Appreciate the response! 😃

[Anonymous]

Hi,
Have you tried to use onsubjobok instead to see if [font=Verdana, Helvetica, Arial, sans-serif]you[/font] will receive only one email alert till the whole subjob (tMysqlinput-->tflowtoiterate-->tjavarow...) finish?
Best regards
Sabrina

[Anonymous]

hi, sorry for the late reply. 

yes, that solved the problem. I used onsubjobok from tflowtoiterate component to sendmail component.

Thank you so much!

[Anonymous]

Hi,
Great it works. Feel free to let us know if there is any further help we can give.
Best regards
Sabrina