Execute a mysql stored procedure in a loop for each row

[Anonymous]

Good morning, 

I have a job in Talend where the functionnal reference of my table is created via a stored procedure. The job is quite simple: get data from table A and insert it in a table B, with a new reference created for each row in table B. 

I use a tMYSQLSP to call my stored procedure.

The reference is create in tMap component by concatening the creation_Date + the output of the stored procedure [ TalendDate.formatDate("yy",row1.DATECRE) + "-" + String.format("%05d", row2.num_ordre) ]

However, the stored procedure is only execute once. I then have the same reference for each row of table B, which is not good. 

How can I make the stored procedure to be executed for each row of table A ?

Thank you

[manodwhb]

@Moe , you can use tFlowtoiterate between table A and procedure. but I am not sure how it is gone get matching data since the procedure looks and not the main.