Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Execute a mysql stored procedure in a loop for each row

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

 

0683p000009Ma6v.png0683p000009Ma68.png

Labels (4)
1 Reply
manodwhb
Champion II
Champion II

@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.