Iterate through Excel rows and run sub-job for each

Anonymous — Mon, 14 Mar 2016 16:12:33 GMT

I am looking for a method of using a tFileInputExcel component to read rows from an excel file each of which will contain a start and end date. For each row I want to populate 2 context variables and run a subjob which will use these values. I am a bit of a Talend beginner and not quite sure how to do this.

Re: Iterate through Excel rows and run sub-job for each

_AnonymousUser — Mon, 14 Mar 2016 21:06:17 GMT

Give this a try:
tFileInputExcel --row1--> tFlowToIterate --Iterate--> tRunJob
in the tRunJob you can pass the values sent to the tFlowToIterate by using the following code:
globalMap.get("row1.columnName")

topic Re: Iterate through Excel rows and run sub-job for each in Talend Studio

Iterate through Excel rows and run sub-job for each

Re: Iterate through Excel rows and run sub-job for each