One Star

Iterate through Excel rows and run sub-job for each

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.
1 REPLY
One Star

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

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")