Call a subjob as many times as the number of data read from a view

[Anonymous]

Hi,

I have the following issue:

I am reading data from a Postgres' view. For instance I have:

uid_view

code_view (values: 1 or 2)

...

I need to the those values two context variable.

I could have many values for uid_view and code_view. If code_view = 1 I have to call mySubjob1 otherwise I have to call mySubjob2. mySubjob1 and mySubjob2 have to be called as many times as the number of uid_view read from the view. I also need to pass uid_view and code_view to both Subjobs as context variable.

How can I do that? Does anyone could help me, please?

Thank you in advance!!

[Anonymous]

check this

[Anonymous]

When you say "subjob" do you mean another job (using a tRunJob) or a section of the current job (https://community.talend.com/t5/Design-and-Development/Difference-between-job-subjob-masterjob-indep...)?

You can potentially achieve this using a tFlowToIterate. What this component does is receive row data, stores the row data one at a time in the globalMap, then calls an iterating link for each row.