One Star

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

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
2 REPLIES
One Star

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

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
One Star

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

Thanks a lot for your help! Much appreciated!