topic Re: Looping over database output and using db field as variable in tRunJob in Talend Studio

Looping over database output and using db field as variable in tRunJob

Anonymous — Thu, 22 Mar 2012 19:31:03 GMT

Hi,
I am storing a list of filenames in a database table. I retrieve these filenames with a tPostgresqlInput component. Next I want to execute a dedicated job for each input row. I added a tRunJob component and created a Iterate row to it (from the tPostgresqlInput). I want to pass the filename to the external job ... how do I achieve this?
tPostgresqlInput - Iterate - tRunjob
Thanks,
Diddy

Re: Looping over database output and using db field as variable in tRunJob

Anonymous — Fri, 23 Mar 2012 03:26:31 GMT

Hi Diddy
You can create a job as follow.
tPostgresqlInput--main(row1)-->tFlowToIterate--Iterate-->tRunjob
Add a context variable "new1" in child job.
Set tRunjob component as Image 1.
Regards,
Pedro

Re: Looping over database output and using db field as variable in tRunJob

Anonymous — Fri, 23 Mar 2012 17:25:35 GMT

Thanks a lot for your help! Much appreciated!